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 are the various Operating system files that every SQL server 2005 database has and what is the purpose.
How do I view a trc file?
Can you insert NULL in unique column?
What are the system database in sql server 2008?
What are Row versions of DataRow?
Do you know what is rank function?
How to truncate the log in sql server 2012? : sql server database administration
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What are the differences between web role and worker role?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is the usage of sign function?
How do you manipulate data?
How to handle error or exception in sql?
How do I trace a query in sql server?
What is sql server profiler?