mysql 查询问题 - 其他数据库开发 / MySQL/Postgresql

有如下记录
mysql> select * from user where city='beijing' or skill='pugong';
+------+---------+---------+--------+----------+
| uid | city | company | skill | zhengshu |
+------+---------+---------+--------+----------+
| 1 | beijing | a | baoan | benke | 
| 1 | nanjing | b | pugong | benke | 
| 2 | shanxi | b | pugong | benke | 
+------+---------+---------+--------+----------+

我想得到在北京工作过的又有pugong技能的人的uid。也就是uid=1。这样的查询能不能得到？？

---

或者

SQL code:
select distinct a.uid
from user a inner join user b on a.uid=b.uid
where a.city='beijing' and b.skill='pugong'