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

Which methodology u follow in testcase?

3 Answers  


Can you explain requirement traceability and its importance?

0 Answers  


What is the mean by Test Management,Test Design,Test Execution,Test Plan,Test Specification?

1 Answers   CSC,


There is a front end application to enter name and marital status. you are provided with a fesh database. On entering 5 set of data at a time an error occured, but on entering rest of the records you were not able to reproduce it. What could have been the reason for the error.

2 Answers   ACS,


When requirement / SRS document comes to a tester then Do we prepare the test cases +ve & -ve at a time?

4 Answers  






how do you ensure by testing that the transactional refuilement or an application are met

1 Answers  


Diff between static and dynamic review?

3 Answers   Softdel,


what is the use of l10n testing?

0 Answers  


Difference between Severity & Priority?

14 Answers   IBM,


How do you go about testing a web application?

2 Answers  


Notepad(Editor),we test is which type of testing? a)Functionality Testing,b)Compatability Testing,c) All,d) None

2 Answers   ADITI,


What is reliable testing? Give me an example

2 Answers   Accenture,


Categories