Рет қаралды 385
SQL Query based Multiple Choice Question with Answer | SQL Quiz Part 3 | SQL Quiz based on GROUP BY and HAVING concepts
Follow me on Social Networking Sites :
------------------------------------------------------------------------------------
*Twitter:
/ sunilkr5672
*Instagram :
/ itjunction4all
-------------------------------------------------------------------------------------
Table and Insert Scripts for Practice
------------------------------------------------------------------
Create Table EmpData (
NAME varchar(10),
DEPT varchar(10),
SALARY int
)
Insert into EmpData Values('Tom','Finance',8000)
Insert into EmpData Values('David','Admin',6000)
Insert into EmpData Values('Mark','Admin',4000)
Insert into EmpData Values('James','Admin',2000)
Insert into EmpData Values('Charles','Finance',1000)
#sql #sqlinterviewquestions #sqlqueries #itjunction4all