AVG()-
.
COUNT()-
, .
FIRST()-
.
LAST()-
.
MAX()-
.
MIN()-
.
SUM()- .
SQL
UCASE()-
.
LCASE()-
.
MID()-
LEN()- .
ROUND()-
.
NOW()- ,
.
FORMAT()-
.
| 8.2. SQL | |
| ABS(X) | |
| ACOS(X) | |
| ASIN(X) | |
| ATAN(X) | |
| COS(X) | |
| EXP(X) | |
| SIGN(X) | -1, <0,0, =0, +1, >0 |
| LN(X) | |
| MOD(X,Y) | Y |
| CEIL(X) | , |
| ROUND(X,n) | n |
| SIN(X) | |
| SQRT(X) | |
| TAN(X) | |
| FLOOR(X) | |
| LOG(a,X) | |
| SINH(X) | |
| COSH(X) | |
| TANH(X) | |
| TRANC(X,n) | n |
| POWER(A,X) | , |
. , , SQLBase, Centure Inc. @ATAN2(X,Y), Y/X, SIGN(X). , , . , , , .SELECT ENAME, SAL, COMM, FINE, SAL + COMM FINE
FROM EMPLOYEE
ORDER BY DEPNO;
SAL + COMM - FINE , . () .
|
|
|
24 SELECT. SELECT , . , . SELECT :
SELECT *
: " , ". , . , , , . , , . , , , . SELECT, - FirstName LastName, .
SELECT [FirstName], [LastName]
, SELECT FROM ( SELECT, , ). SELECT, FROM, . FROM FROM , . , . , , . FROM SELECT. , tblCustomer, SQL.
SELECT *FROM tblCustomer
tblCustomer ( - ). , SQL. SELECT FirstName, LastName FROM tblCustomer Query→Run (→)
26) SELECT ORDER BY. ORDER BY , \ DESC\ASC. SELECT ( )() FROM ORDER BY () ASC |DESC
SELECT , . , , SELECT FROM, . ( ORDER BY ), . WHERE WHERE . , "" (true), "" (false). SQL , Visual Basic (: >0 =' Smith ')., , (). SQL. SELECT FirstName, LastName, State FROM tblCustomer
|
|
|
WHERE State = 'CA'
Daisy Klein. , WHERE . , Visual Basic , SQL Visual Basic. WHERE, AND OR. , , (Denver) (), .. , . AND, . SELECT FirstName, LastName, City, State FROM tblCustomer WHERE (State = 'CO') AND (City = 'Denver') ThurstonRyan, , . , . , , . (WA) (), OR, , .SELECT FirstName, LastName, City, State FROM tblCustomer WHERE State = 'CO' OR State = 'CA' . , AND OR WHERE. , WHERE WHERE
| < | |||||
| <= | |||||
| > | |||||
| >= | |||||
| = | |||||
| <> | |||||
| BETWEEN | |||||
| LIKE | |||||
| IN | |||||
| 25. BETWEEN , . . , 100 150 (SELECT , FROM WHERE BETWEEN 100 And 150) NOT BETWEEN , ( , 100 150.SELECT ., . FROM WHERE . NOT BETWEEN 100 And 150) LIKE , -: % . _ .[] , .[^] , 27) MYSQL , JOIN, INNER JOIN, LEFT JOIN, RIGHT JOIN. INNER JOIN JOIN ON. , .. , AND OR, . , D_STAFF D_STAFF_PROFILE , . SELECT D_STAFF.S_NAME, D_STAFF.S_EXPERIENCE, D_STAFF_PROFILE.PROFILE_ID FROM D_STAFF INNER JOIN D_STAFF_PROFILE ON D_STAFF_PROFILE.STAFF_ID=D_STAFF.XD_IID ORDER BY D_STAFF.S_EXPERIENCE DESC LEFT JOIN INNER JOIN LEFT JOIN , , INNER LEFT. RIGHT JOIN | 20:10:04 | ||||
28. LEN, MID, UCASE, LCASE HAVING GROUP BY.
|
|
|
LEN() -
, "Address".
SELECT LEN(Address) as LengthOfAddress FROM Persons
MID() - .
SELECT MID(column_name, start [,length]) FROM table_name SELECT MID(City,1,4) as SmallCity FROM Persons UCASE() - .( )SELECT UCASE(column_name) FROM table_name"LastName" "FirstName" "LastName" .
SELECT UCASE(LastName) as LastName,FirstName FROM Persons
LCASE() - .(c ) SELECT LCASE(column_name) FROM table_name SELECT LCASE(LastName) as LastName,FirstName FROM Persons MIN() - . SELECT MIN(column_name) FROM table_name "OrderPrice".SELECT MIN(OrderPrice) AS SmallestOrderPrice FROM Orders MAX() - . SELECT MAX(column_name) FROM table_name "OrderPrice".SELECT MAX(OrderPrice) AS LargestOrderPrice FROM Orders SUM() - . SELECT SUM(column_name) FROM table_name "OrderPrice".SELECT SUM(OrderPrice) AS OrderTotal FROM Orders AVG() - . SELECT AVG(column_name) FROM table_name "OrderPrice". :SELECT AVG(OrderPrice) AS OrderAverage FROM Orders , OrderPrice "OrderPrice". :SELECT Customer FROM OrdersWHERE OrderPrice>(SELECT AVG(OrderPrice) FROM Orders) COUNT() - , .COUNT(COLUMN_NAME) - (NULL ) :
|
|
|
SELECT COUNT(column_name) FROM table_name
SQL COUNT(*)
COUNT (*) - :
SELECT COUNT(*) FROM table_name
SQL COUNT(DISTINCT column_name)
COUNT(DISTINCT COLUMN_NAME) - :
SELECT COUNT(DISTINCT column_name) FROM table_name
SQL COUNT(DISTINCT column_name)
COUNT(DISTINCT COLUMN_NAME) - :
SELECT COUNT(DISTINCT column_name) FROM table_name
"Nilsen".
SELECT COUNT(Customer) AS CustomerNilsen FROM Orders
WHERE Customer='Nilsen'
HAVING - SQL WHERE .
SELECT column_name, aggregate_function(column_name)
FROM table_name
