Answer Posted / cpnagar
select top 1 salary from(select distinct top 3 salary from
emp order by salary desc)as e order by e.salary
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Can you explain the disadvantages/limitation of the cursor?
What different steps will a sql server developer take to secure sql server?
What is sub query and its properties?
What is row-level compre?
How to return the top 5 rows from a select query in ms sql server?
What are some examples of schemas?
Name some of the open source software that you can use in alternative to SSR?
How can you set the threshold at which sql server will generate keysets asynchronously?
Will count(column) include columns with null values in its count?
How to populate a table in sql server?
What is read uncmmited?
what is database replication? : Sql server database administration
How can you know if the row fetched from cursor is still valid in underlying table?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What stored by the master? : sql server database administration