TOP 5 SQL Interview Question |

[@ShubhamSaha-m3h]

nice explain.

[@codinglake]

Thank you

[@Shubhamsaha-vw9rc]

Nice 🎉

[@codinglake]

Thanks 🤗

[@user-gq6cg3ls7f]

Can you provide SQL Script? Create Table, Insert Statement etc...

[@codinglake]

CREATE TABLE emp(
emp_id int NULL,
emp_name varchar(20) NULL,
salary int NULL,
dob date NULL
)
INSERT into emp VALUES (1, 'Rajesh', 1000, '1996-02-05' )
INSERT into emp VALUES (1, 'Rajesh', 1000, '1996-02-05' )
INSERT into emp VALUES (2, 'Yogesh', 1500, '1997-10-08' )
INSERT into emp VALUES (3, 'Rohit', 2000, '1998-11-12' )
INSERT into emp VALUES (4, 'Smriti', 1800, '2020-12-05' )
INSERT into emp VALUES (5, 'Joh', 1300, '1996-01-08' )
INSERT into emp VALUES (6, 'Ankita', 1100, '1996-03-09' )
INSERT into emp VALUES (7, 'Arnav', 1700, '2002-05-05' )
INSERT into emp VALUES (7, 'Arnav', 1700, '2002-05-05' )

[@user-gq6cg3ls7f]

@@codinglake Thanks