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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe bottom-up and top-down approach in testing?

1185


Explain the process of qa testing?

1061


Can manual testing be completely replaced by automation testing?

1072


can u share your though about test leakage matrix with template?

1871


What if the project is not big enough to justify extensive testing?

1018


Explain agile development processes?

988


What are the benefits of automated testing?

1029


How to estimate testing effort ?

1026


What is random testing?

1013


'configuration related errors' in testing means what?

1439


How you will begin to improve the QA process?

3192


How to test and to get the difference between two images which is in the same window?

1987


How is retesting different from regression testing?

1104


What is breadth testing?

990


What do you know about data-driven testing?

1185