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

how to overcome kernel isssues

1687

what types of replication are supported in sql server? : Sql server database administration

1134

How to find which stored procedure is currently running in sql server?

1048

How do I edit a procedure in sql server?

1000

How will you hide an attribute? : sql server analysis services, ssas

1012

How many database files are there in sql server 2000?what are they?

1111

What are the different types of upgrades that can be performed in sql server?

1217

How to access the inserted record of an event?

1110

What are the different types of Indexes available in SQL Server?

1059

How do I view a stored procedure in sql server query?

984

How many full-text indexes can a table have?

1026

Explain tablesample?

1042

What is raid and what are different types of raid levels?

1195

Explain the categories of stored procedure?

982

How do you create type- insensitive operator?

1104