how to retrive only second row from table in sql server
2000?
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
Enlist the priority of the testing tasks defined by the qa team in product development.
What is agile testing and what is the importance of agile testing?
What are the contents of test plans and test cases?
What is code inspection?
How to estimate testing effort ?
What is basic block?
Hi every body i am going to take the ISTQB Foundation level Exam on March 21th 2010, Could any one send some list of question papers and latest Dumps to My mail id: (saran_loyola05@yahoo.co.in). Advance thanks. Regards, Saran
How to know that we have to use which tool for this project?
Can you perform regression testing performed manually?
What are the tables in testplans and testcases?
Will automated testing tools make testing easier?
What are the contents in test plans and test cases?
If there are more number of production defects, how will you tackle the team as a lead
What are test driver and test stub and why it is required?
How to log defect in HP ALM