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

wht type of intersting things sqa have or what is intersting abt sqa and how it will be advanategous for us as a sqa engineer?

1991


What are the benefits of destructive testing?

1136


What is the difference between quality assurance, quality control and testing?

1067


What is the need of test plan document?

1274


How do you train another QA engineer?

2337


hi, my qusetion is that plz send me the complete testplan and test cases of any web application with testing too so i have an idea bcz i have no any experience in it

2079


What is the strategy for automation test plan?

1164


What are the things the tests ensure?

1109


Could you tell me two things you did in your previous assignment (QA/Testing related hopefully) that you are proud of?

2134


What is the difference between Outsourced Testing and Crowdsourced Testing

886


What is quality audit?

1195


What are the different levels in software testing?

1124


How do you perform integration testing?

1327


In asset accounting we are run depreciation in 10% now we are in 6th period . But now our client says that the depreciation percentage is 12% but we have wrongly calculated on 10%. So what are the process we have calculated actual percentage.

1067


What are the defects found in testing banking domain?

1978