CREATE TABLE temp(ID INT,RS INT)
INSERT INTO temp
SELECT 1,1 UNION ALL
SELECT 2,1 UNION ALL
SELECT 3,1 UNION ALL
SELECT 4,0 UNION ALL
SELECT 5,0 UNION ALL
SELECT 6,0 UNION ALL
SELECT 7,0 SELECT max(id),max(rs) FROM temp GROUP BY rs
UNION ALL
SELECT min(id),min(rs) FROM temp GROUP BY rs
1 1
再写一条SQL语句,得到以下结果:
4 1
再写一条SQL语句,得到以下结果:
5 0
再写一条SQL语句,得到以下结果:
9 0谢谢!
你要是非得一句一句来,那得看RS的取值是不是就只有0和1,还是会有2,3,4...还是说,语句中可以直接引用RS的取值?
SELECT MIN(ID), 1 FROM table1 WHERE RS = 1
SELECT MAX(ID), 1 FROM table1 WHERE RS = 1
SELECT MIN(ID), 0 FROM table1 WHERE RS = 0
SELECT MAX(ID), 0 FROM table1 WHERE RS = 0
是这个意思吗?