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 select nth record from a table?

Answer Posted / andy

select a.id,a.name from dept a
where
1= (select COUNT(b.id) from dept b where b.id>a.id)

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Federation Root Database?

104


What are the types of database recovery models?

1129


Can we linked SharePoint to a SQL database?

1036


How do you test your database? : sql server database administration

1027


How to turn off warning messages during php execution?

1051


whats new about truncate in sql server 2008?

2508


Describe in brief system database.

1018


Explain different forms of normalization?

951


Can we shrink data file in sql server?

1055


Which are the new data types introduced in sql server 2008?

887


What happens if you insert a duplicate key for the primary key column in ms sql server?

983


How to use subqueries in the from clause in ms sql server?

1167


What number sorts of privileges are accessible in sql?

1038


there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

930


Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

957