你可能感兴趣的试题
SELECT sno FROM sc WHERE cno=“c1”AND cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”UNION SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND sno IN(SELECT sno FROM sc WHERE cno=“c2”)
SELECT DISTINCT歌手号FROM歌手WHERE最后得分＞=(SELECT MAX(最后得分)FROM歌手WHERE SUBSTR(歌手号，1，1)="2") SELECT DISTINCT歌手号FROM歌手WHERE最后得分＞=(SELECT MIN(最后得分)FROM歌手WHERE SUBSTR(歌手号，1，1)="2") SELECT DISTINCT歌手号FROM歌手WHERE最后得分＞=ANY(SELECT最后得分FROM歌手WHERE SUBSTR(歌手号，1，1)="2") SELECT DISTINCT歌手号FROM歌手WHERE最后得分＞=SOME(SELECT最后得分FROM歌手WHERE SUBSTR(歌手号，1，1)="2")
SELECT *FROM 订单 WHERE SUBSTR (订购单号, 4)="1" SELECT *FROM 订单 WHERE SUBSTR (订购单号, 4, 1)="1" SELECT *FROM 订单 WHERE "1" $订购单号 SELECT *FROM 订单 WHERE RIGHT (订购单号, 1)="1"
SELECT SNAME，AGE FROM S WHERE S# =(SELECT SS# FROM SC WHERE C#='C1') SELECT SNAME，AGE FROM S，SC WHERE S#=SS# AND SC#='C1' SELECT SNAME，AGE FROM S，SC WHERE S#=SS# AND SC#='C1'ORDER BY S# SELECT SNAME，AGE FROM S WHERE S# =(SELECT SS# FROM SC WHERE SC#='C1')
SELECT TAB1.*FROM TAB1 WHERE TAB1.简历Like"篮球" SELECT TAB1.*FROM TAB1 WHERE TAB1.简历Like"*篮球" SELECT TAB1.*FROM TAB1 WHERE TAB1.简历Like"*篮球*" SELECT TAB1.*FROM TAB1 WHERE TAB1.简历Like"篮球*/
SELECT * FROM 订单 WHERE SUBSTR(订购单号，4)=“1” SELECT * FROM 订单 WHERE SUBSTR(订购单号，4，1)=“1” SELECT * FROM 订单 WHERE“1” $订购单号 SELECT * FROM 订单 WHERE RIGHT(订购单号，1)=“1”
SELECT学号FROM SC WHERE课程号=’C1’AND课程号=’C5’ SELECT学号FROM SC WHERE课程号=’C1’AND课程号=(SELECT课程号FROM SC WHERE课程号=’C5’) SELECT学号FROM SC WHERE课程号=’C1’AND学号=(SELECT学号FROM SC WHERE课程号=’C5’) SELECT学号FROM SC WHERE课程号=’C1’AND学号IN(SELECT学号FROM SC WHERE课程号=’C5’)
SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like "篮球" SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like "*篮球" SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like "*篮球*" SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like "篮球*/
SELECT DISTINCT 仓库号 FROM 职工 WHERE 工资＞=ANY;(SELECT MAX(工资) FROM 职工 WHERE 仓库号="WH1") SELECT DISTINCT 仓库号 FROM 职工 WHERE 工资＞=ANY;(SELECT 工资 FROM 职工 WHERE 仓库号="WH1") SELECT DISTINCT 仓库号 FROM 职工 WHERE 工资＞=ALL;(SELECT 工资 FROM 职工 WHERE 仓库号="WH1") SELECT DISTINCT 仓库号 FROM 职工 WHERE 工资＞=ALL;(SELECT MAX(工资)FROM 职工 WHERE 仓库号="WH1")
SELECT TAB1. * FROM TAB1 WHERE TAB1.简历Like"篮球" SELECT TAB1. * FROM TAB1 WHERE TAB1.简历Like" * 篮球" SELECT TAB1. * FROM TAB1 WHERE TAB1.简历Like" * 篮球 * " SELECT TAB1. * FROM TAB1 WHERE TAB1.简历Like"篮球 * "
SELECT sno FROM sc WHERE cno=“c1”AND cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”UNION SELECT sno FROM sc WHERE cno=“c2” SELECT sno FROM sc WHERE cno=“c1”AND sno IN(SELECT sno FROM sc WHERE cno=“c2”)
SELECT DISTINCT产品号FROM产品WHERE单价＞=； (SELECT MAX(单价)FROM产品WHERE SUBSTR(产品号，1，1)="2") SELECT DISTINCT产品号FROM产品WHERE单价＞=； (SELECT MIN(单价)FROM产品WHERE SUBSTR(产品号，1，1)="2") SELECT DISTINCT产品号FROM产品WHERE单价＞=ANY； (SELECT单价FROM产品WHERE SUBSTR(产品号，1，1)="2") SELECT DISTINCT产品号FROM产品WHERE单价＞=SOME； (SELECT单价FROM产品WHERE SUBSTR(产品号，1，1)="2")
SELECT TAB1 * FROM TAB1 WHERE tAb1.简历 Like "篮球" SELECT TAB1 * FROM TAB1 WHERE TAB1.简历 Like "*篮球" SELECT TAB1 * FROM TAB1 WHERE TAB1.简历 Like "*篮球*" SELECT TAB1 * FROM TAB1 WHERE TAB1.简历 Like "篮球*/
SELECT * FROM学生表WHERE"1"$学号 SELECT * FROM学生表WHERE RIGHT(学号，1)="1" SELECT * FROM学生表WHERE SUBSTR(学号，2)="1" SELECT * FROM学生表WHERE SUBSTR(学号，2，1)="1"
SELECT…FROM…ORDER BY SELECT…1WHERE…GROUP BY SELECT…WHERE…HAVING SELECT…FROM…WHERE
SELECT学号FROM SC WHERE课程号=’C1’AND课程号=’C5’ SELECT学号FROM SC WHERE课程号=’C1’AND课程号=(SELECT课程号FROM SC WHERE课程号=’C5’) SELECT学号FROM SC WHERE课程号=’C1’AND学号=(SELECT学号FROM SC WHERE课程号=’C5’) SELECT学号FROM SC WHERE课程号=’C1’AND学号IN(SELECT学号FROM SC WHERE课程号=’C5’)
SELECT * FROM学生表WHERE"1"$学号 SELECT * FROM学生表WHERE RIGHT(学号，1)="1" SELECT * FROM学生表WHERE SUBSTR(学号，2)="1" SELECT * FROM学生表WHERE SUBSTR(学号，2，1)="1"
湘公网安备 43130202000226号