Scribd
Upload
92 views

SQL Query Question

SQL question

Uploaded by

Shreya
Copyright
© © All Rights Reserved
Available Formats
Download as PDF or read online on Scribd
92 views

SQL Query Question

SQL question

Uploaded by

Shreya
Copyright
© © All Rights Reserved
Available Formats
Download as PDF or read online on Scribd
You are on page 1/ 9
* DDL, DMLCOMMANDS : CRUD operations + PRACTICE SELECT STATEMENT + FILTERS(HAVING, WHERE, IN, NOT IN ,BETWEEN) + AGGREGATION (GROUPBY, COUNT,SUM, MAX, MIN,AVG) * ORDER BY é& WILDCARDs + JOINS (INNER, LEFT, RIGHT, FULL, SELF, CROSS) + WINDOWS FUNCTION (RANK,ROW_NUMBER,DENSE_RANK,NTILE, CUME_DIST) + CASE STATEMENT * CTE,SUBQUERIES, TEMP TABLE ,RECURSIVE CTEs + LEAD,LAG, FIRST VALUE, LAST VALUE * STRING FUNCTIONS SQL Statements Execution order GROUP BY AGGREGATE FUNCTIONS HAVING pac JOINS Oh) aa ba Olgas a Faw Ke BL. Rea BCU ZAR le Q:We have one table sequence, write a SQL query to get the desired output. prere [Minseg Man Sea] A 1 3 A 6 A 8 9 8 1 n MAX_Seq from ( Select Name, sequence, sequence-ROW_NUMBER( Jover Q- Write 2 SQL query to get desired output. Input table : Airport Output: SOURCE Pane Eas Pe DELHI MuMeal DELHI MUMBAI DELHI PATNA MUMBAI DELHI BANGALORE PUNE DELHI PATNA CHANDIGARH CHENNAI BANGALORE = PUNE PUNE MUMBAI PUNE BANGALORE Goa HYDERABAD CHANDIGARH CHENNAI PUNE MUMBAL GREED [ess CASE WHEN SOURCE < DESTINATION THEN SOURCE ELSE GOA HYDERABAD IDESTINATION END AS SOURCE , ICASE WHEN SOURCE > DESTINATION THEN SOURCE ELSE Q: Write the SQL Query to get the desired output . Input Table: Employee Output: SE Anil Rajesh. 165000 i Vikas mann 16 7 Raman 62500 2 Nisha 40,000 18 18, Santosh 53750 3B Nidhi 60,000 v7 14 Priya 80,000 18 15 Mohit 45,000 18 16 Rajesh 90,000 - 17 Raman 55,000 16 18 Santosh 65,000.17 Q: Write a SQL query to get the desired output. Input Table : Rough Desired Output: 1 10 9 8 7 © Q: Write a SQL query to get desired output ? Input Table : Salary Output : cos Ss nD Vishal Kaushal Vishal Kaushal 12000 Akshay Kumar 9000 Akshay Kumar 9000 Zishan Khan 3000 Zishan Khan 8000 Katrina Kaif 10000 Khan Zishan 5000 Katrina Kaif 10000.-«JSELECT FNAME, LNAME, S1+S2 AS TOTAL FROM ( SELECT A.ID,A.FNAME,A.LNAME, ISNULL(A.SALARY,@) AS. oa Gs ene Kaushal Vishal 4000 * We have one table Demosales , write Sq! query to get desired output. Input :Demosales Desired Qutput : Ca Foren rod cout O01 PL 5 o1 PL 1 02 P2 1 o1 PL 1 03 P3 3 01 PL 1 o1 PL 1 o1 PL 1 o2 P2 1 03 P3 1 03 P3. 1 IORDER_BY ORDERID; 03 P3. 1 Q: Write a SQL query to get the Desired output from Input Table. Output: Ee Finance 1 2 HR 1 3 7 2 1 Q: Write a SQL query to get the desired output (missing number from the input series) Input Output : (SELECT 1 AS SEQ. ( SELECT MAX(ID) FROM #MISSING_ROWS )AS SELECT SEQ+ ,MAXSEQ FROM CTE WHERE SEQ < MAXSEQ )| SELECT SEQ FROM CTE WHERE SEQ NOT IN (SELECT ID FROM Q: Write the SQL query to get the desired output. Input Table A, B Desired Output: SELECT * FROM #B HERE ID NOT IN (SELECT ID SBS Hs e+ e+e ofsolso + wae TEETH Q: Write SQL query to get the max value from Rows? Input Table : Maxrows Output: a kal S000 foo 0 Rahul 3500, 1000 2200, a Ro ‘Sukarn, 5600, 7757 8897 Se aan Select Name,Max(AMT) as Maxamt from (| iSelect Name,Amount_AS ANT from #maxro ISELECT Nane. | Q: Write SQL query to get desired output. input Table : Teams Output: AUSTRALIA — INDIA, INDIA AUSTRALIA— NEWZEALAND, AUSTRALIA AUSTRALIA ENGLAND ENGLAND ENGLAND- INDIA NEWZEALAND ENGLAND - NEWZEALAND INDIA - NEWZEALAND - '.B.Teamname) As MATCHES from #teams Q: Write the SQL query to get the desired Output ? Input Table : Name Output io Name Ci 1 VISHAL, VISHAL. 2 VISHAL KAUSHAL 3 VISHAL VISHAL 4 KAUSHAL KAUSHAL 5 KAUSHAL VISHAL 6 KAUSHAL KAUSHAL Select Name, ROW_NUMBER() over (Partition by Name lorder by name) as RN Q: Write SQL query to get the desired output. Input Table : Attendance Output: oe

You might also like