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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

how to retrive only second row from table in sql server
2000?

Question Posted / madhuparna

Answer Posted / madhuparna

select top 1 * from (select top 2 * from employee)A

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name the different type of indexes in sql?

965

How do I get to sql server configuration manager?

1010

What is update_statistics command?

1068

What are the steps to follow to configure SQL*Net?

1044

What are the advantages of partitioning?

1130

How do you implement session management in SQL Server mode?

1107

What is sql or structured query language?

1154

What are the main sources of data?

1096

To which devices can a backup be created and where should these devices be located? : sql server management studio

1045

What are the properties and different types of sub-queries?

1011

What is db stored procedure?

880

What is difference between rownum and rowid?

904

How many types of stored procedures are there in sql server?

1016

Explain isolation levels that sql server supports?

1040

How do I find the sql server version?

1027