| MySQL

SELECT column_name, (column_name)
FROM table_name
WHERE  
 column_name

Пример SQL

O_IdOrderDateOrderPriceCustomer
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
SELECT Customer,

(OrderPrice) FROM Orders Customer

Query Result:

Customer
Hansen 2000
Nilsen 1700
Jensen 2000

Теперь давайте посмотрим, что произойдет, если мы не используем запрос :

1
SELECT Customer,

(OrderPrice) FROM Orders

Query Result:

Customer
Hansen 5700
Nilsen 5700
Hansen 5700
Hansen 5700
Jensen 5700
Nilsen 5700

1
2
SELECT Customer,OrderDate,

(OrderPrice) FROM Orders Customer,OrderDate

Comments

 

 
 

 
 

 
 

 
 























 
 

 
 












-



-

 
 

Something I do not understand. Summarize the two columns 20 +5 I go 20 and 5 instead of 25. Somebody tell me .. like this byaku sum.

 
 

 
 

Quoting ageent:


 

Main Menu

SQL-based

Conditions in SQL

SQL Functions

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

1

Advertisement