Answer Posted / raja
select top1 salary from(select distinct top2 salary from
table name order by salary desc)a order by salary
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain why variables called the most powerful component of ssis?
What is transact-sql language?
What is delete query?
Do you know what are the reporting services components?
What happens if the update subquery returns multiple rows in ms sql server?
Will the writetext statement activate a trigger?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Why should you use or avoid select * statements?
What are “lost updates”?
What are the security related catalog views? : sql server security
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to add additional conditions in SQL?
What is database black box testing?
What is equi join with example?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?