Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrive only second row from table in sql server
2000?
- 15 Answers
- 27058 Views
- Cognizant, CTS, I also Faced
- E-Mail Answers
Answer Posted / surenda tarai
select top 1 * from(select top 3 * from tablename order by 1
asc) as at order by 1 desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is a mixed extent? : Sql server administration
Tell me what are the advantages of using stored procedures?
Explain raiserror in sql server?
Explain about remote stored procedure?
What happens if you delete a table that is used by a view?
What is candidate key with example?
What is model database? : SQL Server Architecture
How to select true false based on column value in sql server?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
How to insert multiple rows with one insert statement in ms sql server?
Why we use functions in sql server?
Why are you getting errors when creating a new odbc dsn?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What are the requirements on sql server network connections?
How do you create a data source?
