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

what is the difference between lifecycle model and v-model

6 Answers   Semantic Space,


what is severity?explain with example

11 Answers   IBM, NSN,


When should u feel that u can stop testing now?

11 Answers   iSoft, MBT, TCS, Verisoft,


Test scenario is written by seeing SRS or by seeing application

2 Answers  


What's the role of documentation in QA

1 Answers  


why u have choosn testing other than this, what's ur role and responsibilties.

1 Answers   Oracle,


What is diffrence between iterative model and waterfall model?Explain What is the diffrence between iterative model and prototype model?Explain

6 Answers   IBM,


What is Database Testing? How will you do it?

10 Answers  


I am a fresher.looking for testing jobs.I would like to know what kind of questions will be asked for freshers for the post of test engineer.

1 Answers  


What the purpose of testing?

0 Answers  


Hi, Please can anyone tell me the difference between writing test cases & test scenarios? What all should be included while writing a test scenario?

3 Answers  


If a company is a Software Product based company, whether they should go for CMMI or ISO ?

1 Answers  


Categories