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

Please can any one tell me 1).Types of reports 2).Types of Meetings.

0 Answers  


Login screen with Username, Password input fields,remember me check box,sign in and reset button write Test Cases for GUI, Funcitonal, Negative, Usability and Security testing.

0 Answers  


On Registration Form, if some fields are not mandatory to fill then those fields can accept any invalid input. OR there may have some validation. E.g. Email id field - Not mandatory to fill. If user enter Email id = 453454 should it accept?

1 Answers  


Q5. An expert based test estimation is also known as A. Narrow band Delphi B. Wide band Delphi C. Bespoke Delphi D. Robust Delphi

6 Answers   ISTQB, Mercer, Seed Infotech,


test cases for internet explorer

2 Answers   College School Exams Tests, Wipro,


what are the general problems in web testing?

2 Answers   Verizon,


Can u plz write/tell me 2 main Negative Test Cases for my Mobile Phone.

7 Answers   Xavient,


What are the issues that u observed in the kick-off meeting?

7 Answers   Midas Technologies,


what is a RAD (Rapid Application Development) Model when do the firm go for such a model?

2 Answers  


What r the features,u take care in prototype testing?

0 Answers   Satyam,


What is V-model and explain differences between V-model and other SDLC models like waterfall, spiral etc

1 Answers  


tell me about detailed process of bug tracking in your company?questions was asked in interveiw?

4 Answers   TCS,


Categories