SELECT (SELECT a
FROM tab
WHERE a =
(SELECT MAX(a)
FROM tab)),
((SELECT b
FROM tab
WHERE a =
(SELECT MAX(a)
FROM tab))),
(SELECT c
FROM tab
WHERE c =
(SELECT MAX(c)
FROM tab)),
((SELECT d
FROM tab
WHERE c =
(SELECT MAX(c)
FROM tab)))
FROM tab
WHERE a =
(SELECT MAX(a)
FROM tab)),
((SELECT b
FROM tab
WHERE a =
(SELECT MAX(a)
FROM tab))),
(SELECT c
FROM tab
WHERE c =
(SELECT MAX(c)
FROM tab)),
((SELECT d
FROM tab
WHERE c =
(SELECT MAX(c)
FROM tab)))
--------------------------
9 8 3 4
5 6 7 8就是查詢a 的最大的比如上面的數據9,8
查詢c 中最大的數據比如7,8
查詢結果是
a b c d
-----------------
9 8 7 8
只要Select max(a),max(b),max(c),max(d) from tab
就ok拉
(SELECT MAX(a) MaxA,1 AS X
FROM tab) A,
(SELECT MAX(b) MaxB,1 AS X
FROM tab) B,
(SELECT MAX(c) MaxC,1 AS X
FROM tab) C,
(SELECT MAX(d) MaxD,1 AS X
FROM tab) D
WHERE A.X=B.X AND B.X=C.X AND C.X=D.X
SELECT MAX(a),MAX(b),MAX(c),MAX(d)
from tab group by a,b,c,d
(select a,b from tab where a=(select max(a) from tab)) as table1,
(select c,d from tab where c=(select max(c) from tab)) as table2
select * from
(select a,b,1 as X from tab where a=(select max(a) from tab)) A,
(select c,d,1 AS X from tab where c=(select max(c) from tab)) B
WHERE A.X=B.X
只是求a 的最大帶出b
c 的最大帶出d