-
How to list employees names hired AFTER a certain date
I need to list the employees hired after any random date, lets say 10th December 2010 in ascending order and minus their salary by 100% how would I do this?
-
Find second lowest salary from emp table
Display the second lowest salary from emp table without using min & all
-
SQL Query to find out the Maximum marks for each subject
Students table contains studentid, subjectid and marks. Where there are 10 subjects and 50 students. what is the Query to find out the Maximum marks obtained in each subject.
-
Query to find the list of employees age > 30
Write a query to find the list of employees whos age is greater than 30 or so given a date of birth column
-
Sql query to obtain 2nd highest mark in each subject for a student
Given a table with 3 columns StudentName,Subject and Marks.Write a sql to retrieve second highest Marks Obtained for each student.
-
SQL - Find top two salary for each department
1. top 2 salary in each dept2. 2nd maximum sal in each dept3. 2nd minimum sal in each dept.
SQL Interview Questions
Ans