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
How can I get data from a database on another server?
How will you find out if there are expensive SQL statements running or not?
Explain table valued parameters in sql server? Why tvp used?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is BCNF? How is it better than 2NF & 3NF?
What does it mean if @@cursor_row returns a negative number?
Does a server store data?
How many clustered indexes there can be on table ?
What are the lambda triggers?
Explain log shipping?
Can we update data in a view?
How to execute a sql statement using odbc_exec()?
What is difference between createstatement and preparedstatement?
What are the events recorded in a transaction log?
What is spatial and temporal data?