Re: Using MAX() or MIN()

[John Winter]

Hi,

for most popular:

select * from table order by mov_popularity desc limit 1

for least popular:

select * from table order by mov_popularity asc limit 1


min() and max() are only useful when returning 1 field.