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

why exactly we need qa(quality analyst)?what is the diff btw quality analyst qnd quality assurance?

3 Answers   IBM,


who will give priority and severity for testcases?

5 Answers  


is the transmission line voltage delta confoguration?

0 Answers  


what is QA/QC LIFE CYCLE?

3 Answers   Gradient Technologies, Ordain Solutions,


Why we do load and performance testing?

0 Answers  


What type of document produce SRS. WHAT type of document produce FS(functional spec.) what type of document produce SDS(design spec.) Please give me a hierarchy of process of document, which the companies follow

3 Answers   Aloha Technology, Microsoft,


What if the software is so buggy it ca not really be tested at all?

0 Answers  


Q) Create Preffered customer: As a customer when i purchase more than $5000 in goods since my first purchase, I become a preffered customer so that i can receive the benefits associated with that status.

0 Answers   NTT Data,


Please give me your definition of software test engineer.

5 Answers   Lucent,


how to access a build & wat is its configuration.

0 Answers  


Explain what are test driver and test stub and why it is required?

0 Answers  


Adhoc testing is done ?(a)without proper testplan and without proper test cases (b)without proper testplan and with proper testcases (c)Both a & b (d) none of the above ? PLZ explain....Thanks in ADVANCE

2 Answers   Logica CMG,


Categories