过年后论坛最高分,求简精SQL语句 本帖最后由 bonlog 于 2012-02-03 09:03:03 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from wc wwhere left(sku,8)='77735041'and er=(select min(er) from wc where left(sku,8)='77735041') SELECT wc.* FROM wc, (SELECT MIN(IF(c = '1/', id, NULL)) idMin, MIN(IF(c = '/', id, NULL)) idMax, IF(c = '', id, NULL) only FROM (SELECT REPLACE( SUBSTR(sku, LOCATE('-', sku) + 1), SUBSTR(sku, LOCATE('/', sku) + 1), '' ) c, wc.id FROM wc WHERE sku LIKE '20095107%') t) t WHERE wc.id = t.only OR wc.id BETWEEN t.idMin AND t.idMax SELECT * FROM wc wWHERE er=(SELECT MIN(er) FROM wc WHERE LEFT(sku,8)='20095105') SELECT * FROM wc w,(SELECT MIN(er) er FROM wc WHERE LEFT(sku,8)='20095105')tWHERE w.er=t.er全部参照了1楼 select * from wc wwhere er=(select min(er) from wc where left(sku,8)='77735041') SELECT * FROM wc w,(SELECT MIN(er) er FROM wc WHERE LEFT(sku,8)='20095105')tWHERE w.er=t.er MySQL默认字符集的问题 考试答卷__答题完全正确学生统计HQL语句 建立trigger权限不足,求教了 MySQL结果集太大 怎样取得插入记录的ID,ID是用Auto Increment的 在VB中如何使用ADO连POSTGRES? 难道MYSQL连SQL语句的Exists都不支持吗? PHP,MYSQL 见不到 急急急 数据库中存储了一个数据量很大的表格,如何进行显示? 请教一条SQL语句 C连接MYSQL源码
where left(sku,8)='77735041'
and er=(select min(er) from wc where left(sku,8)='77735041')
wc.*
FROM
wc,
(SELECT
MIN(IF(c = '1/', id, NULL)) idMin,
MIN(IF(c = '/', id, NULL)) idMax,
IF(c = '', id, NULL) only
FROM
(SELECT
REPLACE(
SUBSTR(sku, LOCATE('-', sku) + 1),
SUBSTR(sku, LOCATE('/', sku) + 1),
''
) c,
wc.id
FROM
wc
WHERE sku LIKE '20095107%') t) t
WHERE wc.id = t.only
OR wc.id BETWEEN t.idMin
AND t.idMax
WHERE er=(SELECT MIN(er) FROM wc WHERE LEFT(sku,8)='20095105')
SELECT * FROM wc w,(SELECT MIN(er) er FROM wc WHERE LEFT(sku,8)='20095105')t
WHERE w.er=t.er全部参照了1楼
where er=(select min(er) from wc where left(sku,8)='77735041')
WHERE w.er=t.er