SQL - A Simple SubQuery Example

Published: 05 July 2022
on channel: James Flippin

A Simple SubQuery Example.

To create a table like that used in this video:

create database Demos;
use Demos;

CREATE TABLE `employee`
(
`emp_id` int NOT NULL AUTO_INCREMENT,
`emp_name` varchar(50) DEFAULT NULL,
`dept_name` varchar(50) DEFAULT NULL,
`salary` int DEFAULT NULL,
PRIMARY KEY (`emp_id`)
);

insert into employee
(emp_name, dept_name, salary)
values
('Darth Vader', 'Empire', 1000000),
('Darth Maul', 'Empire', 200000),
('Genral Grievous', 'Confederacy of Indepentent Systems', 50000),
('Luke Skywalker', 'Rebel Alliance', 1200000),
('Leia Organa', 'Princess - Alderaan', 2000000),
('Obi-Wan Kenobi', 'Rebell Alliance', 800000),
('Cara Dune', 'Independent', 600000),
('Din Djarin', 'Mandalorian', 450000);

On this page of the site you can watch the video online SQL - A Simple SubQuery Example with a duration of hours minute second in good quality, which was uploaded by the user James Flippin 05 July 2022, share the link with friends and acquaintances, this video has already been watched No times on youtube and it was liked by 0 viewers. Enjoy your viewing!

12,955