Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> rowcount > 2
Hi to all, then, I have this query, i would that only group with 2 or
more row will be showed. How I can I obtain it?
SELECT mal, sin, percent FROM lsa WHERE sin
NOT IN
(SELECT sin FROM lsa WHERE sin<>1 AND sin<>2) ORDER BY mal, sin,
percent
The result of this query is:
MAL SIN PERCENT 1 1 30 1 2 50 2 1 25 2 2 75 3 1 100
In this case i should not view the lastrow (3 - 1 - 100), how can I realize it? Received on Fri Jun 22 2007 - 12:44:35 CDT