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 output of testplan?

1 Answers  


What is capture/replay tool?

0 Answers  


What is 'Context Driven Testing' in Agile Method?

3 Answers   L&T,


What is the Capability Maturity Model (CMM)? At what CMM level were the last few companies you worked?

1 Answers   IBM,


What are the responsibilities of a qa analyst?

0 Answers  


What is traceability matrix? Is it required for every project?

0 Answers  


in v model of software testing which processes comes under QA and which processes comes under QC?And what is verification and validation please anwer these question i realy very confused

9 Answers   KPIT,


what is diff b/w load testing and volume testing?

4 Answers  


What is process area in cmmi?

0 Answers  


Will automated testing tools make testing easier?

0 Answers  


Explain the difference between the verification and validation?

0 Answers  


How to start testing after project kick off ???

2 Answers   CTS,


Categories