Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> rowcount > 2

rowcount > 2

From: Mariano <mariano.calandra_at_gmail.com>
Date: Fri, 22 Jun 2007 10:44:35 -0700
Message-ID: <1182534275.758057.268200@p77g2000hsh.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US