TOP 10 within a group - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

TOP 10 within a group

Message

15/06/2004 18:35:10

Fred Besterwitch
Cyberlogic Pty Ltd
Melbourne, Australie

15/06/2004 11:55:14

Fabio Lunardon
Lunacom
Marostica, Italie

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: TOP 10 within a group

Divers

Thread ID:

00913710

Message ID:

00914081

Vues:

Thanks Fabio. I appreciate your valuable time.

>

>SELECT suppliercode, productcode, dollarsales
>	FROM SuppTable
>	WHERE productcode IN ( SELECT TOP 10 productcode
>				FROM SuppTable top10
>				WHERE top10.suppliercode = SuppTable.suppliercode
>				ORDER BY dollarsales DESCENDING )
>

Fred Besterwitch, MCP

The harder you work. The luckier you get.

Répondre

Fil

Voir

Click here to load this message in the networking platform