SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

count problem

user598242Oct 3 2007 — edited Oct 3 2007

I have a table with two columns: id, package
like:
id package
-----------------------------
1 TV
2 CD
1 CD
1 DVD
3 TV
I want get the id which has package 'TV' and his total records in this table is less than 4.
How should i do? Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2007

Added on Oct 3 2007

7 comments

1,424 views