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.
the sql would be
I gotta keep learning...
posted 6 years ago
Not sure why you need the SubQuery
HQL = "from File where size>0" seems sufficient to me as this query will return only Files whose size is > 0. Unless the data that you provided is wrong and there are cases where the File Name is same but the size maybe 0 or other values