how to retrive only second row from table in sql server
2000?
- 3 Answers
- 6796 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / nagapawan
eg:
select top2 * from tablename
this table retrive only second row only
from 2nd row if u want only number and name
then like this we have to write
eg:
select top2 empno,ename from emp
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is Operational testing?
Define the role of qa in software development?
Explain the difference between the verification and validation?
Explain what is the rule of a "test driven development"?
What is validation and verification in software testing?
Tell me some key points to consider while writing a bug report.
When a non-conformance is noted during these "reviews", what happens next?
Describe use case testing?
How are the quality assurance activities planned ?
What should your qa documents include?
Write the differences between preventive and reactive approaches?
What is change request?
what is difference between smoke testing and sanity testing?
Explain the difference between quality control and quality assurance.
In an example of a Bank Teller requesting that her computer program should include an addition that shows the full Customer Profile on her main screen, what would a Waterfall vs. Agile approach include and/or look like for such a request?
