Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reversing an order
Message
 
À
04/02/2014 10:22:27
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 9.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01593113
Message ID:
01593122
Vues:
37
>Here is a puzzle. I have a table that contains annual records for businesses. There may or may not be a record for a given business in any given year. So for BusinessA there may be records for 2000, 2003, 2004, 2008, 2010, 2012, etc. I want to SELECT the most recent 3 records. That is easy enough.
SELECT TOP 3 * FROM [HistoricalSummary] WHERE business=@business ORDER BY [year] desc
But now here's the problem. I want the order of these records to be sorted by year lowest to highest. So this is the opposite of what is needed to get the 3 latest records. Has anyone dealt with anything like this before?
>Thanks
SELECT *
FROM (SELECT TOP 3 * FROM [HistoricalSummary] WHERE business=@business ORDER BY [year] desc) Tbl1
ORDER BY Year 
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform