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

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

Question Posted / lakram5455

Answer Posted / lakram5455

SELECT TOP(3) * FROM emp ORDER BY EId DESC

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between union, intersect, and minus operators?

1139

Why we should not use triggers?

1014

What is the new security features added in sql server 2016? : sql server security

1162

What are the triggers in sql?

1168

Define left outer join?

1027

Differentiate between a local and a global temporary table?

998

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

195

What is public role in sql server?

1211

How to use union to merge outputs from two queries together in ms sql server?

1134

What is Command line parameters in PLSQL.?

1190

How to use the inserted and deleted pseudo tables?

1003

What are the differences between having and where clause.

1016

How to encrypt data between dialogs?

1167

Tell me what is log shipping?

1032

What is replace and stuff function in sql server?

1113