作者sss88340 (仲夏夜)
看板Database
标题[SQL ] SQL语法问题
时间Mon Apr 1 12:34:50 2013
name street city
a aaa bbb
b bbb ccc
c aaa bbb
d ccc ddd
e eee fff
f ggg hhh
我该如何选出同样street跟city的name
筛选出 a跟c
资料库都已经建好了只差不会筛选出来
有谁能够帮忙一下
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 134.208.33.130
1F：推 twoseven:SELECT * from @Table t1 WHERE (SELECT COUNT(*) FROM 04/01 15:55
2F：→ twoseven: @Table t2 WHERE t1.street = t2.street AND t1.city = 04/01 15:56
3F：→ twoseven:t2.city) > 1 04/01 15:56
4F：→ sss88340:t1.street那边显示错误 04/01 16:52
5F：推 cloudsan:显示什麽错误也要提一下呀~ 04/02 03:07