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
Where are SQL server users names and passwords are stored in sql server?
How to defragment indexes with alter index ... Reorganize?
How to list all objects in a given schema?
Which joins are sql server default?
Which are the important points to note when multilanguage data is stored in a table?
What is create command?
What is ssl in sql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is scheduled job and how to create it?
How to change server name in sql server?
How to check parameter value in stored procedure sql server?
How does normalization work?
What are different types of roles provided by ssrs?
What are “lost updates”?
Do you know exporting and importing utility?