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

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_ID	OrderDate	OrderPrice	Client
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:

Client	SOMME (OrderPrice)
Nilsen	1700

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

Résultat Requête:

Client	SOMME (OrderPrice)
Hansen	2000
Jensen	2000

Address
E-mail	ageent.ua @ gmail.com ageent.ru @ gmail.com
Téléphone	Mobile: +380 54 501 90 28
Sites Web	Imprimer

Синтаксис SQL AYANT

Пример SQL AYANT

Commentaires

Menu Principal

Basé sur SQL

Conditions dans SQL

Fonctions SQL

Autorisation

Nice, l'Ajax Sondage

Lequel de mes extensions est le meilleur?

Statistiques

Newsline

Publicité