sql经典语句（SQL classic sentences）.docVIP

sql经典语句（SQL classic sentences） I. Basic operation 1) DESC, the describe role is to display the structure of the data table using the form: desc data table name 2) distinct eliminates duplicate data usage: select, distinct, field name, from data table 3) order by field 1 ASC, field 2 desc 4) nested queries select, emp.empno, emp.ename, emp.job, emp.sal From scott.emp Where sal= (select, Sal, from, scott.emp, where, ename =WARD); 5) nested queries select, emp.empno, emp.ename, emp.job, in, emp.sal From scott.emp Where, Sal, in (select, Sal, from, scott.emp, where, ename =WARD); 6) nested queries select, emp.empno, emp.ename, emp.job, any, emp.sal From scott.emp Where Sal any (select, Sal, from, scott.emp, where, job =MANAGER); Equivalent to (1) select, Sal, from, scott.emp, where, job =MANAGER (2) select, emp.empno, emp.ename, emp.job, emp.sal From scott.emp Data found in where Sal (1) data a, or, Sal (1), data found in B, or, Sal (1), C Eg: Select, Sal, from, scott.emp, where, job =MANAGERresults; 12,10,13 Equivalent to sal=12,10,13 or SAL (12, OR, 10, OR, 13) 7) the intersection operation is the intersection concept in the set. The sum of the elements that belong to the set A and belongs to the set B is the intersection. In the command edit area, execute the following statement. Eg: (select, djbh, from, ck_rwd_hz) intersect (select, djbh, from, ck_rwd_mx) documents numbered the same Select * from ck_rwd_mx a, ((select, djbh, from, ck_rwd_hz) intersect (select, djbh, from, ck_rwd_mx)) B Where a.djbh =b.djbh Two function 1) ceil takes the minimum integer ceil (N) greater than or equal to the value N; select, Mgr, mgr/100, ceil (mgr/100), from, scott.emp; 2) floor takes the maximum integer floor (N) less than or equal to the value N; select, Mgr, mgr/100, floor (mgr/100), from, scott.emp; 3) the remainder of mod m divisible by mod (m, n) n 4) power, m, N, square, mod (m, n) 5) round m four, five, keep the n bit mod (m, n) Select round (8.655,2) from dual; 8.66 Sele