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

hi, i am recently joining a SW house as a QA but i have no any experirnce in it so i need some help to solve this my question is that what is the staring steps to make the test plan of web application and also how make the test case

2 Answers  


What is the diff b/w Quality Assurence and Quality Control ?..

11 Answers   FIC, Visualize Technology,


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

1 Answers   Oracle,


What is object repository?

2 Answers   Cognizant, CTS,


what are the metrics you are following?

1 Answers   Cap Gemini,






WHAT IS A DIFFERENCE BETWEEN BUG AND DEFECT

12 Answers   HCL,


Life for QA & job oppurtunity ?

2 Answers  


We have a directory structure /usr/local/jboss/server/{$app_name}/log/*.log which contains 1000 log files. A web application has been logging to the cloud.log file, the attempts of a user called test. The code logs the following way: log.debug(username); where the username equals “test”. What command line application and or combinations of applications will you call in order to create a file named user_log.csv that contains the following lines, where the timestamp is sorted: timestamp,username

0 Answers  


What is a frame work or project frame work?

2 Answers   BirlaSoft,


List out the software quality practices through the software development cycle?

0 Answers  


Can anybody help me what is the diff between CMM,SEI,PCMM and six sigma?

6 Answers  


what is system specification ? what is functional specification?

0 Answers  


Categories