SQL Queries - Real time frequently asked by Companies - PART 3/5 - Questions

I have started posting a series of sqlserver queries that are asked in interviews. This can be a great start of practising the queries.

This is the third part of the series. I suggest you to view the PART 1, PART 2 for better visibility.

Happy Job Hunt!! ALL THE BEST!!

1.        Write a query to find TOP X records from each group?

2.        Write a query to find Max Salary from each department?

3.        There is a table which contains two columns Student and Marks. Now, we need to find all the students, whose marks are greater than average marks i.e. list of above average students?

4.        Write a query to find duplicate rows in a table?

5.        Write a query to find current system date?

6.        Write a query to display the date in MM/DD/YYYY format?

7.        Write a query to get only time part of a date time data type?

8.        Write a query to find year from date?

9.        Write a query to find the difference in days between two dates?

10.     Write a query to add or subtract days in a date?