how to retrive only second row from table in sql server
2000?
Answer Posted / prabhat sharma
select top 1 * from xyz where rno > (select top 1 rno from xyz)
rno is a column name and xyz is a table name
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you know what is normalization of database? What are its benefits?
What are the differences between char and nchar in ms sql server?
How to recover from sql injection? : sql server security
In which tcp/ip port does sql server run? Can it be changed?
how to define testing of network layers? : Sql server database administration
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is acid properties?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How to use transact-sql statements to access the database engine?
What is model database in sql server?
How do you delete a trigger?
What is 5nf in normalization form?
How to stop a loop early with break statements in ms sql server?
What are cascading parameters in ssrs reports?