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
whats new about truncate in sql server 2008?
How to change server name in sql server?
What is 3nf normalization form?
What are Row versions of DataRow?
List out some of the requirements to set up a sql server failover cluster?
What is difference between index seek vs. Index scan?
What are the purposes of floor and sign functions?
How to get the definition of a trigger back?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How you can get a list of all the table constraints in a database? : Sql server administration
What is the synonym of join?
List all types of constraints in sql server?
Can I work with several databases simultaneously? : sql server management studio
How to select all columns of all rows from a table with a select statement in ms sql server?
What is sql or structured query language?