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

Disadvantages of the indexes?

1125

What are sp_configure commands and set commands?

1023

how we use window authentication connection with sql server.?

1152

How to use copy and concatenate commands in SQL?

1141

What are the different acid properties?

1066

How do you clear a log file?

1048

Explain what are the different index configurations a table can have?

1110

How to update a field in SQL after ALTERING a row?

1232

How to get a list of columns in a view using the "sp_help" stored procedure?

1033

Write a SQL query to make a column as unique?

1040

How to create prepared statements using odbc_prepare()?

1065

How can I know what locks are running on which resource?

957

what is a deadlock? : Sql server database administration

1064

What is buffer cash in sql server?

1152

What are different types of replication in sql server?

1085