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
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What are sub reports?
Explain identity in sql server?
Explain what is public role in sql server?
How can you hide the sql server instances?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
How to list all triggers in the database with sys.triggers in ms sql server?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What are the types of table?
What is data mart? : sql server analysis services, ssas
How to use old values to define new values in update statements in ms sql server?
How to automatically create a log when an exception is being received into SQL Server?
What is ddl command?
What are the advantages of stored procedure in sql server?
Are connections to sql server encrypted?