how to retrive only second row from table in sql server
2000?
Answer Posted / yogesh
select top 1 from tablename where id <(select top 1 id from
test)
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a transactions?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What specific conditions database should meet, before you can bulk copy data into it using bcp?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is update locks?
How you can get a list of all the table constraints in a database?
What is indexing in sql server with example?
how to use DTS package in 2000,2005,2008 in sql server
What is the difference between Normalization and De-normalization?
Explain system functions or built-in functions? What are different types of system functions?
how would you store your query in an SSRS report or a Database server?
Does a specific recovery model need to be used for a replicated database? : sql server replication
How to define output parameters in stored procedures?
Explain datetime2 data type in sal server 2008?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?