how to retrive only second row from table in sql server
2000?
Answer Posted / shashikant
select min(id) from cms_dfm where id in (SELECT TOP 2 ID
from CMS_DFM Order by
ID desc)
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
How you can change the database name in SQL SERVER?
What is a trigger and types of a trigger?
How to enforce security in sql server? : sql server security
How to create a simple stored procedure in ms sql server?
What is replication with database mirroring? : sql server database administration
How to connect php with different port numbers?
Tell me what is the difference between locking and multi-versioning?
How to loop through result set objects using mssql_fetch_array()?
what is the maximum size of a row? : Sql server database administration
How do I perform an unattended install of sql server 2000?
What are the types of stored procedures in an sql server?
How many joins in sql server?
What is similarity and difference between truncate and delete in sql?
What is pivot and unpivot?
Differentiate between a local and a global temporary table?