国产免费制服丝袜网站,91啪在线观看国产在线,亚洲欧洲专线一区

mysql查出n條數(shù)據(jù)，其中有四條數(shù)據(jù)兩兩重復(fù)，還有其他的也是這樣，如何去重？

2023-06-18 14:11

1個回答

2023-06-18 18:13

SELECT * FROM(
select * from customer where user=(
SELECT source_user from customer WHERE user='admin') UNION ALL select * from customer where user=(
select source_user from customer where user=(
SELECT source_user from customer WHERE user='admin')) union ALL select * from customer where user=(
select source_user from customer where user=(
select source_user from customer where user=(
SELECT source_user from customer WHERE user='admin'))) UNION ALL select * from customer where source_user=(/*我的上線的上線的user*/
select user from customer where user=(
select source_user from customer where user=(
SELECT source_user from customer WHERE user='admin'))) union all select * from customer where source_user=(/*我的上線的上線的上線user*/
select user from customer where user=(
select source_user from customer where user=(
select source_user from customer where user=(
SELECT source_user from customer WHERE user='admin'))))) as alias group by user;

相關(guān)問答

mysql如何查詢最新的5條數(shù)據(jù)

2個回答2022-12-15 11:08

進(jìn)入mysql管理頁面，點擊進(jìn)行執(zhí)行SQL語句頁面，輸入以下內(nèi)容：SELECT * from 你要查的表名 where 自增長的主鍵/日期 ORDER BY createtime DESC LIMIT...

全文

mysql數(shù)據(jù)庫如何查詢一條記錄？

1個回答2022-12-15 18:25

不知道你用的什么語言這是sql語句 select * from use u where u.name=? and u.pass = ? 如果數(shù)據(jù)庫里有這條記錄就會返回1或更多沒有就返回0 然后在判斷...

全文

mysql：只用一條sql語句，如何查出一個表里，不同條件對應(yīng)的數(shù)據(jù)條數(shù)

1個回答2022-11-01 11:58

看一下這個SQL select sum( if((sex?=?1?and?age?=?2),1,0) ), sum( if((sex?=?1?and?age?=?5),1,0) ), sum( if...