posted 14 years ago
Hi All
Another query to ask here. we have a table
File(name ,date, file_size).
anyone has simple query to list name of file where the related size is not 0
let me give some sample data.
name date size
a 1/1/2001 0
a 2/1/2002 2
a 3/3/2003 0
b 1/1/2000 3
b 2/2/2001 4
If I run the query, it should list "b" only as "a" has two related size = 0.
I know the sql for it. but seems contain subquery and complex. so I am after a simple HQL
Thanks in advance.
Steven
the sql would be