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 / ravi

Answer Posted / ravi

select top 2 from tablename

Is This Answer Correct ?    6 Yes 28 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are “lost updates”?

1043

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

1051

Explain the functionalities that views support?

1162

What is row_number () and partition by in sql server?

1134

What are a database and a data warehouse?

1072

What is the difference between locking and multi-versioning?

1038

Can you roll back the ddl statement in a trigger?

1021

What is shrink log file?

952

What stored procedure would you use to view lock information?

1017

Explain trigger and trigger types?

1035

Describe the functionalities that views support.

1146

What is the default Port No on which SQL Server listens?

1175

What is difference between commit and rollback when used in transactions?

1016

What are the features of Embedded SQL

1173

How can I tell if sql server is 32 or 64 bit?

1013