how to retrive only second row from table?

Answers were Sorted based on User's Feedback



how to retrive only second row from table?..

Answer / 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

how to retrive only second row from table?..

Answer / sivakumar

select * from citizen limit 1,1

Is This Answer Correct ?    0 Yes 0 No

how to retrive only second row from table?..

Answer / karthik rahul

HI guys

THis Is Karthik Rahul


I think to select the data from second row of a particular
table, we must know at least one coloumn value on that
particular table......

if it is wrong pl. send da correct one ro my mail
karthik_lboy@yahoo.co.in

9985315383 Hyderabad

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Manual Testing Interview Questions

i m doing a course in manual testing ,they ll be conducting a online exam.i just need a sample question paper with answer.

0 Answers  


If you are the Test Team Leader and one of the Team Member is not supporting and not working according to your expectations what would you do? how will u handle him?

3 Answers  


If there is non reproducible bug which developer is not ready to agree, how you will convince him.

3 Answers   HCL,


1.what is Exhaustive Testing, Statement Testing, coverage Testing, Decision Testing & Condition Testing?

0 Answers  


Hello Friends, I m working as tester in a company, i have 1.5 yrs of exp., in my company we used manual testing Technique & i wants to give The ISTQB Certified Tester-Foundation Level certificate Exam. Can any one tell me the next date of the exam.? If anyboady have questions papers OR any material then pls. frwd me on my id : preet45p@yahoo.com Thanks in advanced.

3 Answers  






Test approach to windows update?

0 Answers   ADITI,


what is manual testing process

4 Answers   TCS,


What is diff b/n TRM(Test Responsibility Matrix) and RTM (requirement Tracebility matrix) or both are same??

5 Answers  


What are different types of metrics used in testing ?

1 Answers  


McroSoft Six rules standard for Userinterface testing?

2 Answers   IBM,


WHAT IS THE DIFFERENCE BETWEEN PRIORITY AND SEVEARITY ?

2 Answers  


How will u classify the test cases ?

5 Answers  


Categories