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

how to get 25th row in any table in sqlserver can u tell me
syntax

Answer Posted / a.alagu ganesh

We create index colomn in that table . use that index
coloum we take the 25th row of that table .

Example

SELECT * FROM table1 WHERE index_coloumn = 25

Is This Answer Correct ?    4 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain what is indexed view? How to create it?

850


What are the differences between left join and inner join in sql server?

1038


Do you know the cursor optimization tips?

929


What are the steps to process a single select statement?

887


Explain about extended stored procedure?

862


which backup strategy you are following at ur company

2103


Write SQL queries on Self Join and Inner Join.

1070


When should you use an instead of trigger?

917


Which tcp/ip port does sql server run on? How can it be changed?

976


How to disable triggers using "disable trigger"?

999


How network traffic be reduced by using the stored procedure?

1044


Mention the differences between substr and charindex in sql server.

982


Explain Geography datatype in SQL Server

1059


what is an extended stored procedure? : Sql server database administration

989


How to recover from sql injection? : sql server security

954