Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

9985315383 Hyderabad

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Manual Testing Interview Questions

HI FRNDS, I HAVE 2.5 years OF exp In Manual Testing,Plz let me know if thr r any oppurtunities in any company in Bangalore Thanks in Advance

0 Answers  

What is ADHOC testing ?

9 Answers   NIIT,

Hi! I have got an expirence of a year in Software(manual) testing...Kindly let me if there are any openings for the same,location :MUMBAI..i have got a knowledge of C++,sql (basic),java,and have done a automation testing course..

1 Answers  

How do you get programmers to build testability support into their code?

0 Answers   TCS,

what is builr release team..?

4 Answers   Accenture,

Explain Load testing

7 Answers   CSC,

what is BVA,EP?if any body knows this, post the answer for me.

3 Answers  

Hi Friends, I am going to give Foundation Level Testing Exam from ISTQB, I need its dumps and study material. Please help me if any one has. Thanks in Advance

2 Answers   CMC,

if it is a web testing,what is a dead link and a broken link.,and what are the other things we test in a web application related to functionality other than field level and form level validations.

2 Answers  

for example, we have old password,confirmed password, new password followed by submit button. what are the test cases written for that?

9 Answers   Semantic Space,

Is thr any standard format for Test Case ID like... TC_applicationname_deveopername_date_modulenumber or else we can give any ID which is unique entire the application?? plz clear my doubt...

2 Answers  

What is the difference between white and black box testing?

4 Answers