| 01 |
AVG:平均數(shù) |
SELECT AVG(Realtime) FROM realtime_film; |
| 02 |
COUNT:計(jì)數(shù) |
SELECT COUNT(Realtime) FROM realtime_film; |
| 03 |
DISTINCT:唯一值 |
SELECT DISTINCT Screen_time FROM realtime_film ; |
| 04 |
MAX:最大值 |
SELECT MAX(sum_movie)FROM realtime_film; |
| 05 |
MIN:最小值 |
SELECT MIN(sum_movie)FROM realtime_film; |
| 06 |
SUM:全值相加 |
SELECT MIN(sum_movie)FROM realtime_film; |
| 07 |
GROUP BY:根據(jù)一個或多個列的結(jié)果排序 |
SELECT Customer,OrderDate,SUM(OrderPrice) FROM Orders GROUP BY Customer,OrderDate |
| 08 |
DELECT:刪除語句 |
DELETE FROM table_name [WHERE Clause] |
| 09 |
LIKE |
SELECT field1, field2,...fieldN table_name1, table_name2... WHERE field1 LIKE condition1 [AND [OR]] filed2 = 'somevalue' |
| 10 |
ORDER BY:升序或降序排列 |
SELECT field1, field2,...fieldN table_name1,table_name2...ORDER BY field1, [field2...] [ASC [DESC]] |
