If you like this video please
like share , subscribe and comment down below..
if you have any suggestion or doubt this video.
Scripts:
CREATE TABLE emp(
emp_id int NULL,
emp_name varchar(20) NULL,
salary int NULL,
gender char(1) NULL
)
insert into emp VALUES (1, 'Rajesh', 1000, 'M')
insert into emp VALUES (1, 'Rajesh', 1000, 'M')
insert into emp VALUES (2, 'Yogesh', 1500, 'M')
insert into emp VALUES (3, 'Rohit', 2000, 'M')
insert into emp VALUES (4, 'Smriti', 1800, 'F')
insert into emp VALUES (5, 'Joh', 1300, 'M')
insert into emp VALUES (6, 'Ankita', 1100, 'F')
insert into emp VALUES (7, 'Arnav', 1700, 'M')
insert into emp VALUES (7, 'Arnav', 1700,'M')
insert into emp VALUES (8, 'tony', 1400, 'M')
