谁能帮我提供查询（select）语句

select '经典' from dual

经典select 语句select * (或字段名)
from 表名
where 条件

select *
from 表
where 条件 = “经典”

SQL> help select SELECT
------ Use this command to retrieve data from one or more tables, object
tables, views, object views, or snapshots. SELECT
   [ DISTINCT | ALL ]
   { *
   | { [ schema. ]{ table | view | snapshot } .*
     | expr [ [ AS ] c_alias ] }
   [, { [ schema. ]{ table | view | snapshot } .*
      | expr [ [ AS ] c_alias ] } ] ...
FROM
   { [ schema. ]
     { table [ PARTITION ( partition_name ) | @dblink ]
     | [ view | snapshot ] [ @dblink ] }
   [ t_alias ]
   | [ THE ] ( subquery )
   [ t_alias ]
   | TABLE ( nested_table_column )
   [ t_alias ] }
   [, { [ schema. ]
        { table [ PARTITION ( partition_name ) | @dblink ]
        | [ view | snapshot ] [ @dblink ] }
      [ t_alias ]
      | [ THE ] ( subquery )
      [ t_alias ]
      | TABLE ( nested_table_column ) } ] ...
   [ WHERE condition ]
   [ [ START WITH condition ] CONNECT BY condition
     | GROUP BY expr [, expr] ...
     [ HAVING CONDITION ] ] ...
   [ { UNION
     | UNION ALL
     | INTERSECT
     | MINUS } SELECT command ]
   [ ORDER BY { expr | position | c_alias } [ ASC | DESC ]
   [, { expr | position | c_alias } [ ASC | DESC ] ] ...
   | FOR UPDATE
     [ OF [ [ schema. ]{ table. | view. } ] column
          [, [ [schema.]{table. | view.} ] column] ...] [NOWAIT] For detailed information on this command, see the Oracle8 Server SQL
Reference.
SELECT (Embedded SQL)
--------------------- Use this command to retrieve data from one or more tables, views, or
snapshots, assigning the selected values to host variables. EXEC SQL
   [ AT { dbname | :host_variable } ]
   SELECT select_list
INTO
   :host_variable [ [ INDICATOR ] :indicator_variable ]
   [, :host_variable [ [ INDICATOR ] :indicator_variable ] ] ...
FROM table _list
[ WHERE condition ]
[ [ START WITH condition ] CONNECT BY condition
   | GROUP BY expr [, expr ] ... [ HAVING condition ] ] ...
[ { UNION
   | UNION ALL
   | INTERSECT
   | MINUS } SELECT command ]
[ ORDER BY
   { expr | position } [ ASC | DESC ]
   [, { expr | position } [ ASC | DESC ] ] ...
   | FOR UPDATE
     [ OF [ [ schema. ]{ table. | view. } ] column ]
     [, OF [ [ schema. ]{ table. | view. } ] column ] ...
     [ NOWAIT ]  ... ] For detailed information on this command, see the Oracle8 Server SQL
Reference.
SELECT INTO Statement
--------------------- The SELECT INTO statement retrieves data from one or more database tables,
then assigns the selected values to variables or fields. select_into_statement
   SELECT
     [DISTINCT | ALL]
     {* | select_item[, select_item]...}
   INTO
     {variable_name[, variable_name]... | record_name}
   FROM
     {table_reference | (subquery)}
     [alias]
     [, {table_reference | (subquery)}
       [alias] ]...
     rest_of_select_statement; select_item
   { function_name[(parameter_name[, parameter_name]...)]
   | NULL
   | numeric_literal
   | [schema_name.]{table_name | view_name}.*
   | [[schema_name.]{table_name. | view_name.}]column_name
   | sequence_name.{CURRVAL | NEXTVAL}
   | 'text'}
   [ [AS] alias ] table_reference
   [schema_name.]{table_name | view_name}[@dblink_name] For detailed information on this statement, see the PL/SQL User's Guide and
Reference.
SQL>

看 oracle sql 参考手册就好

//操作符
--算术
+ - * /
--比较操作符
= != < > <= >= BETWEEN...AND IN
SELECT * FROM BOOK WHERE PRICE BETWEEN 44 AND 60
--逻辑操作符
AND OR NOT
--集合操作符
SELECT ISBN,TITLE FROM BOOK UNION SELECT AUTHORID,NAME FROM AUTHOR
SELECT ISBN,TITLE FROM BOOK UNION SELECT ISBN,TITLE FROM BOOK
SELECT ISBN,TITLE FROM BOOK UNION ALL SELECT ISBN,TITLE FROM BOOK
--交集
SELECT AUTHORID FROM BOOK INTERSECT SELECT AUTHORID FROM AUTHOR
--减集
SELECT AUTHORID FROM AUTHOR MINUS SELECT AUTHORID FROM BOOK
--连接操作符
||//连接查询
select isbn,title,book.authorid,name from book,author where book.authorid = author.authorid
--内连接
select * from book a inner join author b on a.authorid = b.authorid
--左外连接
select * from author a left join book b on a.authorid = b.authorid
--右外连接
select * from author a right join book b on a.authorid = b.authorid
--全外连接
select * from book a full outer join author b on a.authorid = b.authorid//SQL函数
--日期函数
SELECT ADD_MONTHS(SYSDATE,2) FROM DUAL
SELECT MONTHS_BETWEEN(SYSDATE,TO_DATE('2006-01-01','YYYY-MM-DD')) FROM DUAL
SELECT LAST_DAY(SYSDATE) FROM DUAL
SELECT ROUND(SYSDATE,'DAY') FROM DUAL --四舍五入到最靠近的星期日
SELECT NEXT_DAY(SYSDATE,'星期日') FROM DUAL
SELECT TRUNC(SYSDATE,'YEAR') FROM DUAL --截断惟有格式模型指定的单位的日期
SELECT EXTRACT(MONTH FROM SYSDATE) FROM DUAL--字符函数
select initcap('hello') from dual;
select lower('FUN') from dual;
select upper('sun') from dual;
select ltrim( 'xyzadams','xyz') from dual;
select rtrim('xyzadams','ams') from dual;
select replace('jack and jue' ,'j','bl') from dual;
select instr ('worldwide','d') from dual;
select substr('abcdefg',3,2) from dual;
select concat ('Hello',' world') from dual;
SELECT CHR(67) FROM dual;--根据ASCII码返回对应字符
SELECT LPAD('function',15,'=') FROM dual;--用=从左填充function使长度达到15位
SELECT TRIM (LEADING 9 FROM 99998769789999) FROM dual;
SELECT TRIM (TRAILING 9 FROM 99998769789999) FROM dual;
SELECT TRIM (9 FROM 9999876789999) FROM dual;
SELECT LENGTH('frances') FROM dual;
SELECT TRANSLATE('JACK','ABCD','1234') FROM DUAL
SELECT DECODE(SEX,'男','男作者','女','女作者') FROM AUTHOR--数字函数
select abs(-15) from dual;--绝对值
select ceil(44.778) from dual;--向上取整
select sin(1.571) from dual;
select cos(0) from dual;
select sign(-99) from dual;--取符号
select floor(100.2) from dual;--向下取整
select power(4,2) from dual;
select mod(10,3) from dual;
select round(100.256,2) from dual;--四舍五入
select trunc(100.9999,2) from dual;--截断保留两位小数
select sqrt(4) from dual;--转换函数
SELECT TO_CHAR(SYSDATE,'YYYY"年"mm"月"dd"日"') FROM DUAL
SELECT TO_DATE('2005-12-06' , 'yyyy-mm-dd') FROM dual;
SELECT TO_NUMBER('22') FROM DUAL;--其他函数
SELECT NVL2(NULL,'0','1') FROM DUAL
select nullif('aa','aa') from dual --相等返回null否则参数一--分组函数
SELECT TYPE,SUM(PRICE) FROM BOOK GROUP BY TYPE HAVING TYPE <> '计算机语言'
SELECT TYPE,AVG(PRICE) FROM BOOK
SELECT TYPE,MAX(PRICE) FROM BOOK
SELECT TYPE,MIN(PRICE) FROM BOOK
SELECT count(*) FROM BOOK--分析函数
值相同排名不同
select title,price,row_number() over(order by price) as price from book
select title,type,price,row_number() over(partition by type order by price) as rank from book
值相同排名相同排名不连续
select title,type,price,rank() over(order by price) as rank from book
值相同排名相同排名连续
select title,type,price,dense_rank() over(order by price) as rank from book

调试易

谁能帮我提供查询（select）语句

解决方案 »