Selecting Top Records
June 21, 2013 Leave a comment
//Selecting top 2 records among all records
SELECT TOP 2 * FROM PurchaseTable
SELECT TOP 3 * FROM PurchaseTable WHERE Code = ‘XX0001’ ORDER BY PurchaseDate DESC
try to be a lady who can satisfy and have a positive thinking
Linnaryone
- DELETE Table Vs TRUNCATE Table
- Selecting Top Records
- Selecting Special Characters
- Restoring Database
- Capability Maturity Model Integration(CMMI Level 5)
- ISO 12207 Standard for Software Development Life Cycle
- Agile Model (One of the SDLC Model)
- Waterfall Model (One of Widely Used SDLC Model)
- Systems Development Life Cycle (SDLC)
- Get value from drop down list inside the Grid View
Linnaryone 