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

what for cmmi and iso(what are they) are used and how we can use them in our testing and whole work related to sqa.Do it has any kind of format if it has kindly tell me from whr i will get it kindly give detalied answer?

0 Answers  


What is your hierarchy in your organization?

2 Answers   Cap Gemini,


What are the tools used by a tester while testing?

0 Answers  


difference between qa and qc?

4 Answers  


How do you determine which piece of software require how much testing?

0 Answers  


List out the difference between Verification and Validation.

7 Answers  


How do you differentiate between priority and severity of the defect within the project?

0 Answers  


What is Recovery Testing?

5 Answers  


what are the advantages of process in Quality Assurance?

1 Answers  


What is meant by Bidirectional Tracebility matrix?

3 Answers   AZTEC,


What are ISO standards? Why are they important?

2 Answers   Berger Paints, Vaal University of Technology,


what is the difference between quality assurance and quality control

4 Answers   BIPL, BJIT, Cap Gemini, SouthTech,


Categories