Answer Posted / kk
select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tell me what are the advantages of using stored procedures?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What are the different types of locks in the database?
What are rest-style architecture's?
What is the use of =,==,=== operators?
What is it’s similarity with sql server?
How to convert a table data in XML format in sql server?
How to convert a unicode strings to non-unicode strings?
Do you know what is difference between index seek vs. Index scan?
Can group by be used without aggregate functions?
What are the new features of sql server 2012 reporting service?
What are the dis_advantages of stored procedures, triggers, indexes?
Explain a checkpoint?
What is indexing in sql server with example?