> prova=> select sno,qty from sp group by sno,qty having qty=300;> ERROR: This is not a valid having query!
Use WHERE for conditions like this.
SELECT sno, qty FROM sp WHERE qty=300 GROUP BY sno;
Taral