Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

how to identify metrics, integrity level, identify risks and identify security issues in ieee 829 standard explain with examples??

0 Answers  


What is quality control?

6 Answers   Ordain Solutions,


what is Conventional SPMs

0 Answers  


What's the role of documentation in QA

1 Answers  


What is the difference between Test cases document and test cases design document?

0 Answers  


How much Salary can u ask for Manual Tester Position with 1+yrs of Experience in an MNC like Infosys?

7 Answers   3D PLM, Geometric Software, Infosys,


What is the Difference between 2-tier and 3 tier applications... Anybody can explain in detail... Thanks in advance

3 Answers   Siemens,


A payroll system?

0 Answers   E-Clear Technologies,


How would you describe the involvement you have had with the bug-fix cycle between Development and QA?

1 Answers  


What is the difference between the test plan and test strategy

0 Answers  


is the transmission line voltage delta confoguration?

0 Answers  


hi, my qusetion is that plz send me the complete testplan and test cases of any web application with testing too so i have an idea bcz i have no any experience in it

0 Answers   QA,


Categories