','))+1withaas(select'ABC,AA,AD,ABD,JI,CC,ALSKD,ALDKDJ'idfromdual)selectregexp_substr(id,'[^,]+',1,rownum) idfromaconnectbyrownum <= length(regexp_replace(id,'[^,]+'))--分组加排序,数据量大时结果会比较慢SELECTlistagg(t.ename,',')WITHINGROUP(ORDERBYt.sal)FROM...
select name,population,area from World where area>=3000000or population>=25000000/* Write your T-SQL query statement below */select name,population,area from World where area>=3000000or population>=25000000/* Write your PL/SQL query statement below */select name"name",population"population",area...
SELECTstock_name,SUM(CASEWHENoperation='Buy'THENprice*(-1)ELSEpriceEND)AScapital_gain_lossFROMStocksGROUPBYstock_name; 总结:开始感觉自己思路很厉害 还特意先去看视频学了ROW_NUMBER() 也用上了今天刚学的 SELF JOIN和ON clause中的“>”的trick 结果看到讨论区别人的代码发现从一开始思路就输了... 最...
or population >=25000000 /* Write your T-SQL query statement below */ select name,population,area from World where area>=3000000 or population >=25000000 /* Write your PL/SQL query statement below */ select name "name", population "population", area "area" from World where area>=3000000 ...
metronidazole price buy generic trimethoprim order cephalexin 500mg generic Reply Tqprat May 12, 2023 at 2:34 am vermox 100mg over the counter buy vermox 100mg online buy tadalafil online cheap Reply Bmdrjg May 12, 2023 at 3:25 pm brand cleocin 150mg order cleocin 150mg sale order sild...