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 / priya

select top 3 from <table name > where < specify any
condition> order by <column ID> desc

Is This Answer Correct ?    15 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difference between primary key and unique key? : sql server database administration

939


Can you explain full-text query in sql server?

1011


How retrieve field names from the table in SQL through JAVA code?

1905


your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

984


How to list all dsn entries on your local machine using odbc_data_source()?

1037


What is query optimizer in sql server?

1018


Do you know the capabilities of cursors?

1149


Differentiate between SQL and ORACLE joins and write their syntax.

1033


What is @@rowcount in sql?

1003


What is difference between index seek vs. Index scan?

1155


What is a non equi join?

979


How to defragment indexes with alter index ... Reorganize?

1083


when would you go for denormalization? : Sql server database administration

869


Why is sql server log file full?

1031


Explain the phases a transaction has to undergo?

1057