" /> Mot de passe <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />
Accueil Ayant SQL
PDF

AYANT

Синтаксис SQL AYANT

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value

Пример SQL AYANT

Nous avons le tableau suivant "Commandes":

O_IDOrderDateOrderPriceClient
1 2008/11/12 1000 Hansen
2 2008/10/23 1600 Nilsen
3 2008/09/02 700 Hansen
4 2008/09/03 300 Hansen
5 2008/08/30 2000 Jensen
6 2008/10/04 100 Nilsen

1
2
3
SELECT Client,SUM(OrderPrice) FROM Commandes
GROUP BY Client
HAVING SUM(OrderPrice)<2000

Résultat Requête:

ClientSOMME (OrderPrice)
Nilsen 1700

1
2
3
4
SELECT Client,SUM(OrderPrice) FROM Commandes
WHERE Client="Hansen" OR Client="Jensen"
GROUP BY Client
HAVING SUM(OrderPrice)>1500

Résultat Requête:

ClientSOMME (OrderPrice)
Hansen 2000
Jensen 2000

Commentaires

 
+7 #1 Шелест Константин 2010-10-29 01:04

Citer
 
 
-5 #2 Алекс 2010-11-19 16:39 Citer
 
 
+4 #3 KJHJ 2010-12-14 09:02
Citer
 
 
0 #4 KJHJ 2010-12-14 09:03 Citer
 
 
+1 #5 Arai 2011-03-30 06:58 Citer
 
 
-1 #6 SERG_ 2011-04-11 13:49






Citer
 
 
-1 #7 TheDreamCatcher 2011-04-24 08:29


Citer
 
 
+2 #8 Yury 2011-05-17 12:46



Citer
 
 
0 #9 Andrey 2011-08-22 22:48 Citer
 
 
0 #10 Xzels 2012-04-12 13:43
Citer
 

Autorisation

Nice, l'Ajax Sondage

Lequel de mes extensions est le meilleur?

Statistiques

Publicité