:select * from table1 where 范围 :insert into table1(field1,field2) values(value1,value2)delete from table1 where 范围 :update table1 set field1=value1 where 范围 :select .

--得到所有的最高级单位 select * from com_unit where parent_unit is null--得到有一. COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO这样的话更复杂的查询写.

create table Dept(deptno number primary key ,deptname varchar(50),peonum number)我刚试了一个表,然后就发现不对,╮(╯▽╰)╭

1、Alter table LOANS add [备注说明] varchar(20) 2、Select 出版社,KCSL as 库存量,总价/KCSL as 平均单价 From (Select 出版社,count(索书号) as KCSL,sum(价格.

select name,sum(qty) from table where yearmonth>= '200801' and yearmonth<= '200912' group by name having sum(qty) >= 10000 and sum(qty) <= 50000

select 购买者,(购买商品数量*商品单价) as 交易金额 from 交易记录表 where 交易金额>300

其实用不到那么多`` 像下面的: 把查询条件装到一个User对象里 //得到要查询的sql语句 private String getSql(User user) { // TODO Auto-generated method stub StringBuffer .

这句应该能得到你要查询的结果: SELECT [语文]=CASE WHEN [语文]>80 THEN 'YOU' WHEN [语文]>=60 AND [语文]<=80 THEN 'JIGE' ELSE 'BU' END, [数学]=CASE .

就这样写:select * from 表名 where (a=20 and b=50) or (a=50 orb=20) order by id desc

select 学生表.学号,学生表.姓名,课程表.课程名称 from 学生表,课程表,成绩表 where 学生表.学号 = 成绩表.学号 and 课程表.课程号 = 成绩表.课程号 and 成绩表.成绩 < 60