-
select length(' my hell oword '); select length(ltrim(' my hell oword ')); select length(rtrim(' my hell oword ')); select length(trim(' my hell oword ')); select trim(leading '?' from '??My Hello Word???'); select replace('??mys?ql???','?','--');查看全部
-
select format(123456.789,2); select lower('MyHelloWord'); select upper('MyHelloWord'); select left('MyHelloWord',2); select lower(left('MyHelloWord',7)); select lower(right('MyHelloWord',4)); select length('slkjlksjlksjlkljka'); select ltrim(' my hell oword ');查看全部
-
delete t1 from tdb_goods as t1 left join (select goods_id,goods_name from tdb_goods group by goods_name having count(goods_name) >=2) as t2 on t1.goods_name=t2.goods_name where t1.goods_id > t2.goods_id;查看全部
-
select * from a left join b on a.x=b.x left join c on c.y=a.y;查看全部
-
关键字和函数名全部大写查看全部
-
常用命令查看全部
-
创建数据表的同时将查询结果写入到数据表查看全部
-
表的连接类型查看全部
-
表的连接查看全部
-
多表更新查看全部
-
ANY SOME ALL 关键字使用原则查看全部
-
子查询需注意查看全部
-
子查询查看全部
-
SELECT 语句查看全部
-
DELETE语句查看全部
举报
0/150
提交
取消