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 is test metric is software testing and what information does it contains?

0 Answers  


what is Agile Development Processes

1 Answers  


What is negative testing? How is it different from positive testing?

0 Answers  


write an e-mail introducing yourself to the client as a QA ead is not in town.

0 Answers   QA,


How do you know that your test cases will meet the requirement that the client required for the application.

3 Answers   Engineering,


Iam very much confused about the meaning of black box testing methodoly ? I am getting diffrent types of answer for it ...Pls Help

6 Answers  


WHAT IS "DELIVERED DEFECT DENSITY"

2 Answers  


How do you promote the concept of phase containment and defect prevention?

2 Answers  


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

2 Answers  


What do you think would be a perfect testing tool for waterfall model?

2 Answers  


What is backus-naur form?

0 Answers  


what is the difference between functional requirements and non functional requirements? Which things will come in bothe categories?

12 Answers  


Categories