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

Синтаксис SQL

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

Abbiamo la seguente tabella "Ordini":

O_Id	DataOrdine	OrderPrice	Cliente
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 Cliente,SUM(OrderPrice) FROM Ordini
GROUP BY Cliente
HAVING SUM(OrderPrice)<2000

Cliente
Nilsen	1700

SELECT Cliente,SUM(OrderPrice) FROM Ordini
WHERE Cliente='Hansen' OR Cliente=
GROUP BY Cliente
HAVING SUM(OrderPrice)>1500

Cliente
Hansen	2000
Jensen	2000

Address
E-mail	ageent.ua @ gmail.com ageent.ru @ gmail.com
Telefono	Cellulare: +380 54 501 90 28
Siti Web	Stampa

Синтаксис SQL

Пример SQL

Commenti

Menu Principale

Basati su SQL

Condizioni in SQL

SQL Funzioni

Autorizzazione

Nizza Ajax Sondaggio

Statistica

Newsline

Pubblicità