How to filter max value records in SQL query -

i want records except max value records. pls suggest query that.

for eg,(im taking avg field filter)

sno   name     avg 1     aaa       85 2     bbb       90 3     ccc       75 

the query needs return 1st , 3rd records.

use below query:

select * tab avg<(select max(avg) tab);