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 / arun kumar k s

Answer Posted / arun kumar k s

drop table #temp select top 2 identity(int,1,1) as SlNo, *
into #temp from TABLE_NAME select * from #temp where SlNo=2

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to enter binary string literals in ms sql server?

1096

Give main differences between "Truncate" and "Delete".

1032

How to select true false based on column value in sql server?

953

How to find the service pack installed? : sql server database administration

971

What is indexing explain it with an example?

931

What does nvl stand for?

905

Which are new data types introduced in sql server 2008?

988

What are temporal tables in sql server 2016?

839

how we use window authentication connection with sql server.?

1084

What is NOT NULL Constraint in sql server 2012?

935

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1087

What is the sql server agent?

1032

Explain about system database?

999

What is BCP? When does it used in sql server 2012?

999

What is a transaction and why is it important?

999