how to retrive only second row from table in sql server
2000?
Answer Posted / ramana
Table Like this
Create Table Employee(Name varchar(20),Location
varchar(20),Salary int)
Query Like this
Select top 1 * from employee where Name not in(select top 1
Name from Employee)
it will display second record....
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Can we use where clause with group by?
Which is the main third-party tool used in sql server?
What are different types of raid configurations? : SQL Server Architecture
What are the new data types are introduced in sql 2000?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What are the properties of the transaction?
How to Insert multiple rows with a single insert statement?
Explain transaction server isolation?
define and explain the differences between clustered and non-clustered indexes.
How to drop an existing table with "drop table" statements in ms sql server?
What is a field in a table?
Mention the uses of stored procedures.
What is normalization 1nf 2nf 3nf?
What is difference between primary key and foreign key?
Can primary key be a foreign key?