SQL Interview Questions And Answers Part 63
Problem Statement :- Staff Table has two columns namely Id and Name.
Write an SQL query to get the expected output :-
-------------------------------------------------------------------------
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
-------------------------------------------------------------------------
*Instagram :
/ itjunction4all
*Twitter:
/ sunilkr5672
-------------------------------------------------------------------------
Table and Insert SQL Script :
-------------------------------------------------------------------------
create table Staff_Tbl
(
Id int,
Name varchar(40)
);
insert into Staff_Tbl values (1, 'Staff1');
insert into Staff_Tbl values (2, 'Staff2');
insert into Staff_Tbl values (3, 'Staff3');
insert into Staff_Tbl values (4, 'Staff4');
insert into Staff_Tbl values (5, 'Staff5');
insert into Staff_Tbl values (6, 'Staff6');
insert into Staff_Tbl values (7, 'Staff7');
insert into Staff_Tbl values (8, 'Staff8');
#SQL #SQLInterviewQuestionsandanswers #sqlInterviewQuestions #ITJunction4All