老哥们,sql求助
盐湖城的长颈鹿
2022-06-16 16:11
之前没写过sql语句,只会一点最基本的select,好哥哥们,下面的这个应该怎么写啊
比如这种的结果就应该是B、C
虎扑JR1389273242
SELECT t.namefrom test tWHERE t.cell_id = 1 and t.type_id = 2 and not EXISTS ( SELECT t2.name from test t2 WHERE t2.cell_id = 2 and t2.type_id = 3 and t2.dace = 4 and t2.name = t.name)
清梦星河
竟然在虎扑看到这个