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


Please Help Members By Posting Answers For Below Questions

Explain the difference between quality control and quality assurance.

582


What is extreme programming and what is it got to do with testing?

541


How Google apps can be considered ? Either they are product or Project

1210


What is meant by Factory testing?? I have seen this one in a Job posting

1631


What should Development require of QA?

1773






What actually a SQA Tester do in His/ Her first (entry level) Job?

1671


Hi QA, Do any QA's give us the detail status of review happening during the entire life cycle (if templates includes it will be very useful for us) ?

1668


What is the need of test plan document?

634


How is retesting different from regression testing?

561


A payroll system?

1196


According to you, when is the good time to start qa in a project?

549


What is the difference in responsibilities of programmers and qa analyst?

622


What are the differences between test strategy and test plan?

580


What is the difference between Test cases document and test cases design document?

539


i completed btech in IT in 2012.i am not good at programming.i want to do software testing.am i eligible for the course and how will be my future?please help and than you

3610