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
What happens if time-only values are provided as date and time literals?
Explain active/passive and active/active cluster configurations?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
can you instantiate a com object by using t-sql? : Sql server database administration
What are the main sources of data?
What is the sql case statement used for?
What is a hint?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is normalization of database?
What is the stuff?
What are the recovery models for a database?
What are sub reports?
What are the ways available in sql server to execute sql statements?
what is an extended stored procedure? : Sql server database administration