how to retrive only second row from table in sql server
2000?
Answer Posted / belson gnana pradeep
SELECT TOP 1 salary FROM
(SELECT DISTINCT TOP 2 salary FROM employee
ORDER BY salary DESC) a ORDER BY salary
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can coalesce return null?
What is ms sql server reporting services?
What is the return type of executeupdate ()?
Mention the differences between having and where clause.
Explain the steps to use transact-sql cursor?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What do you mean by data manipulation language?
In which format does an image save in SQL Server database ?
What is use of except clause? How it differs from not in clause?
What is difference between view and materialized view?
What is the difference between Stored Procedures and triggers?
What is a not null constraint?
how you can list all the tables in a database?
What is instead of dml trigger?
What is the command used to check locks in microsoft sql server?