Answer Posted / rajasekar
er
# 9
select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I delete a sql server database?
What are the different types of columns types constraints in the sql server?
How to identify current user in ssrs report?
What are data resources?
Explain about Views?
How to count groups returned with the group by clause in ms sql server?
How can we delete a table in sql server?
How to change the data type of an existing column with "alter table" statements in ms sql server?
How to achieve Paging of records in SQL SERVER?
Mention the different types of triggers?
What is SQL Server?
How do you rebuild an identity column?
What is the significance of master, tempdb and model databases?
What is report snapshot in ssrs?
How we can compare two database data?