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

how much testing is enough.and why documentation is needed

2 Answers  


Do we have to execute all the test cases while doing sanity testing and regression testing??(manual testing)

2 Answers  


How to write testcases for a general objects like 1.pen 2.paper 3.printer 4.Mobile 5.Bulb 6.coffee machine 7.calculator 8.Mobile 9.telephone...etc

2 Answers   HCL, iFlex, Intrack, Ordain Solutions, Synechron, TCS,


What do you do in Configuration Management?

1 Answers   Zensar,


How do you test for the coockies for a web application?

0 Answers   SuperValu,






1.The main purpose of integration testing is to find design errors.is it true 2.The testing technique that requires devising test cases to demonstrate that each program function is operational is called ?

2 Answers  


Who is the father of Software Testing? Who has invent the water fall model? Who has invent the spiral model? Who has invent the prototype model? Who has invent the v-v model? Who has invent the Hybrid model?

1 Answers  


I have 6 months experience as project tarine and one and a half year experience as software engineer.Should i write taht my total experience id 2 years.

0 Answers  


what methodologies you are following

6 Answers   Wipro,


what is meant by test stretagy?

2 Answers   Four soft, TCS,


What is traceability matrix? What is recovery scenario? How to pass values into a datatable?

2 Answers   RBS,


Hi..I have 2 years exp in manual. In our company we are using only excel sheet for preparing reports. If possible anyone can send resume format for manual. mail id vdivya_mdu@yahoo.co.in and give some suggestion. thnx

5 Answers   Rhytha Web Solution,


Categories