数据库
极客-杀生丸
这个作者很懒,什么都没留下…
展开
-
检索只使用了P3和P5的工程编号JNO(含S,P,J,SPJ表)
SELECT DISTINCT JNO FROM SPJWHERE JNO IN (SELECT DISTINCT X.JNOFROM SPJ AS X, SPJ AS YWHERE X.JNO=Y.JNOAND X.PNO=‘P3’AND Y.PNO=‘P5’)GROUP BY SPJ.JNOHAVING COUNT(DISTINCT (PNO))=2原创 2020-06-05 20:28:18 · 1309 阅读 · 1 评论 -
数据库分组group by
–从表中通过username进行分组select username,count(*) 用户名数量 from [user] group by username原创 2020-05-29 21:48:54 · 247 阅读 · 0 评论