How to Sort the result in alternate order of Gender in SQL | SQL query
How to Sort the result in alternate order of Gender in SQL ?
This is very important SQL basic question related to Order by clause .
-------------------------------------------------------------------------
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
-------------------------------------------------------------------------
🔴 Instagram :
/ itjunction4all
🔴 Twitter:
/ sunilkr5672
-------------------------------------------------------------------------
🔴 Table and Insert SQL Script :
-------------------------------------------------------------------------
Create Table Emp_Tbl
(id int,
EmpName varchar(20),
Gender varchar(20));
Insert into Emp_Tbl values(1,'Allen','MALE');
Insert into Emp_Tbl values(2,'Benjamin','MALE');
Insert into Emp_Tbl values(3,'Charle','MALE');
Insert into Emp_Tbl values(4,'Daisy','FEMALE');
Insert into Emp_Tbl values(5,'Emma','FEMALE');
#SQL #ORDERBY #SQLInterview #ETLTesting #ITJUNCTION4ALL #SunilKumar
#sqlInterviewQuestions #sqlInterviewQuestionsForTesting #sqlInterviewQuestionsQuery #sqlTechnicalInterviewQuestions