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

wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records

Answer Posted / krishna sandeep

select top 3 <column_name> from ,table_name> order by
<column_name> desc

this will work.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you debug a procedure in sql server?

992


Explain use of expression builder.

1069


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1996


What is a database in ms sql server?

1103


What happens if the update subquery returns multiple rows in ms sql server?

1168


How many levels of sp nesting is possible?

1099


What are different types of join?

1372


How efficient you are in oracle and SQL server?

1218


What is the difference between a unique key and primary key?

1002


How to use linked server?

1269


how to trace the traffic hitting a sql server? : Sql server database administration

1948


What are xml indexes?

1003


What are the disadvantages of indexes?

1151


What is sql server management studio? : sql server management studio

1121


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

1034