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

how to retrive only second row from table in sql server

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


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
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

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More QA Concepts Interview Questions

What is software quality assurance?

1 Answers  

write bug due for a web app in which a text field "phone number" which should allow only 10 numbers,but allows chars, special char and more than 10 numbers in to the field?

2 Answers   NTT Data,

what is the difference b/w qtp,winnrunner,testdirector?

2 Answers  

Is the quality assurance group (for the QAG) audited? Who does these audits?

2 Answers  

Please suggest a Automation Tool that helps in collaborating with teams located in various geographic locations

1 Answers   Elico,

Any Automation tool in the market to help quality test team members communicate with each other? While server startup or restart Which Will inform each member .

0 Answers  

defect, error, failure, fault

4 Answers   Infosys, Quinnox, Redlix,

Give me example of automate the regression test suite ........Thanks...

0 Answers   Apotex,

Questions for role of a QC engineer at NDS,Bangalore 1st round is written 20 questions on aptitude and 10 question on testing Aptitude--problems on time and distance,tap problem,ages,time and work,probability, Testing 1.Difference Between QA & QC 2.Any 4 types of SDLC models with diagram. Also Pros and cons of each model 3.What is application Testing And embedded testing 4.Qualities of a good tester 5.Test cases for registering user. One field for user name,2 fields for password,"ok" and "cancel" button 6.What is a bug,explain Bug life cycle 7.Difference between priority and severity? 8.Some question on software design

0 Answers  

what we have to do in white box testing what will be checked in it and how much its necessary for white box tester to be a good programmer too

2 Answers  

What is code complete?

0 Answers  

What is Defect Density ? What is the formula? Explain with example

4 Answers   Cap Gemini,