home *** CD-ROM | disk | FTP | other *** search
/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / WINDOWS / PROGRAM / WINSQL.ZIP / EXAMPLES.ZIP / QUERY13.SQL < prev    next >
Encoding:
Text File  |  1991-05-01  |  63 b   |  5 lines
  1. select pno
  2.   from sp
  3.   group by pno
  4.   having count(*) > 1;
  5.