what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
Answer Posted / praveen singh
select min(salary) from salary where salary in(select top 3
salary from salary order by salary desc)
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Do you know hot add cpu in sql server 2008?
Describe triggers features and limitations?
What are the different types of sub-queries?
How to get the query of a table in sql server?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
How do you Implement SSIS Packages in your Project?
explain how to create a new schema in a database? : Sql server database administration
what is an extended stored procedure? : Sql server database administration
How to create a dml trigger using create trigger statements?
What is difference between Datepart() and Datename() in SqlServer?
What is the most common type of join?
How to retrieve error messages using odbc_errormsg()?
Explain various On-Delete options in a DB table. Which is the default option?
What is the difference between osql and query analyzer?
Explain differences between web edition and business edition?