Take FREE!! Online Cocubes Mock Test to Crack various Companies Written Exams.
Practice List of Paytm Coding Questions !!!
Take 30+ FREE!! Online Arithmetic Aptitude Mock test to crack any Exams.

Technical Discussion :: SQL

10. Write a query to select the second highest salary from a table.

Answer:

SELECT max(salary) AS salary2 FROM orders WHERE salary < (SELECT max(salary) AS salary1 FROM orders)

Asked In :: TCS Accenture Goldman Sachs

Post Your Answer Here:

Name *
Email
Alert me

Post Your Reply Here:

Report Error

Please Login First Click Here