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

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

0 Answers  


Kindly tell me some good websites from where I can study about sqa and testing(advance and new material)

0 Answers  


What are the five common solutions for software developments problems?

0 Answers  


When there is a new enhancement, what kind of test cases will you write and how will you ensure that everything is covered

2 Answers   FIC,


what type of documents do u prepare during testing

9 Answers   Semantic Space,


How to generate swift message

0 Answers  


What is QA Life cycle

6 Answers   Infosys, UHG,


What is traceability matrix? Is it required for every project?

0 Answers  


What are verification and validation and difference between these two?

0 Answers  


When you realize that there is something wrong in BDD, what will you do ?

4 Answers   ADP,


Why regression testing is important?

0 Answers  


After which phase is the inspection process optional? Choice 1 Preparation Choice 2 Rework Choice 3 Planning Choice 4 Inspection meeting Choice 5 Overview

2 Answers   Brainbench Certification,


Categories