how to retrive only second row from table in sql server
2000?

Answers were Sorted based on User's Feedback



how to retrive only second row from table in sql server 2000?..

Answer / swagata mukherjee

Select < fields names > from <table name > Limit 1,1

Is This Answer Correct ?    0 Yes 0 No

how to retrive only second row from table in sql server 2000?..

Answer / nagapawan

eg:

select top2 * from tablename
this table retrive only second row only

from 2nd row if u want only number and name

then like this we have to write
eg:
select top2 empno,ename from emp

Is This Answer Correct ?    0 Yes 4 No

how to retrive only second row from table in sql server 2000?..

Answer / prakash t

Here you go,

for example , consider one EPmloyee table , to get a 2nd
row :

General syntax :

Select < fields names > from <table name > where rownum
= <row ID>

Ex : select Ename , Eid , Designation from Employee where
rownum=2

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More QA Concepts Interview Questions

Why are you in qa?

0 Answers  


What is validation and verification in software testing?

0 Answers  


Can manual testing be completely replaced by automation testing?

0 Answers  


Can you help me with your suggestions so as to select a test management system that fits perfectly well with the two widely used software development methodologies i.e., agile and waterfall?

1 Answers  


Give me an example of the best and worst experiences you've had with QA.

0 Answers  






How to test Volume in Music System?

1 Answers  


What is test metric is software testing and what information does it contains?

0 Answers  


i have a dout in sevirorty and priority and answer me this question There are 5 bugs A,B,C,D,E In this first two bugs A,B are minor bugs C,D,E are major bugs .From A,B bugs u got those major bug C,D,E then how u will give sevirorty and priority

2 Answers  


How will you manage a team member who is more experienced than yours and what challenges will you face? ( that guy might be technically sound).

0 Answers  


how much it is necessary that if u r a sqa engineer then ur programming should be strong or either u have only concepts of it but u r not a good programmer.If the person is not a good programmer then do they are able to make their carrer in this field of qa and do it has good scope for them being not a good programmer?

0 Answers  


What documents QA team needs from Development to orginize a QA process

4 Answers  


what is the difference between functional requirements and non functional requirements? Which things will come in bothe categories?

12 Answers  


Categories