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
Mention the differences between local and global temporary tables.
How many servers can we create in a single subscription?
What is an example of a primary key?
What is policy management?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What type of locking occurs during the snapshot generation? : sql server replication
What is self join in sql server joins?
What is meant by datasource?
How do I perform an unattended install of sql server 2000?
can an order by clause be used in a creation of a view?
What is ddl and dml commands?
Which is better statement or preparedstatement?
Does group by or order by come first?