find the 3rd max salary

Answer Posted / vaishnavi nigam

SELECT Salary from Emp_sal ORDER BY Salary Desc WHERE Row_Num=3

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is t sql the same as sql server?

522


When I delete any data from a table, does the sql server reduce the size of that table?

590


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

574


Can we perform backup restore operation on tempdb? : sql server database administration

590


How you can get the list of largest tables in a database?

533






Tell me what is normalization? Explain different forms of normalization?

550


Which sql server is best?

520


Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

584


How do I start and stop sql server?

554


What is sql azure database?

188


What are the types of joins in sql?

563


What is the difference between createstatement and preparedstatement?

497


What is in place upgrade in sql server?

526


What are the disadvantages of primary key and foreign key in SQL?

634


What is the definition for sql server 2000?

599