how to retrive only second row from table?

Answer Posted / magesh n

My answer will work in Oracle SQL but not sure in MS-SQL.
Query is:

select * from tablename where rownum=2;

rownum is the pseudo-column in oracle sql.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you use any automation tool for smoke testing?

788


Write 2 scenarios for Integration testing? Please let me know its urgent.

1568


Hi I want to start online training couses for testing Any body plz help me out how to start the online courses Plz post the answer here or send me a mail for kommineni.1020@gmail.com

1714


what is the cheklist to check SRS document (after releasing) as a test ingineer and how can we check

1588


I am DD. I am working as a Tester in e-learning company? IS there scope for content testing? or i have to change to software testing. pls guide me...

1675






tell me 5 new requirements in ur project? plz urgent

1964


Test cases on send/ receive button of Microsoft outlook.

4100


What can you tell about the project if during testing you found 80 bugs in it

1820


What is meant by Boundary value analisis and Equalence partitioning? Can give derive this using these methods? In a system designed to work out the tax to be paid: An employee has £4000 of salary tax free. The next £1500 is taxed at 10% The next £28000 is taxed at 22% Any further amount is taxed at 40% Which of these groups of numbers would fall into the same equivalence class? a) £4800; £14000; £28000 b) £5200; £5500; £28000 c) £28001; £32000; £35000 d) £5800; £28000; £32000

1593


What is ecp (equivalence class partition)?

695


what is test scenario and test condition?

1490


Write the test cases for godaddy home page

1246


What are microsoft 6 rules?

777


what is independent question and what is retriewing and what is problem of severity.

1419


Why should you care about objects and object-oriented testing?

1924