It's actually more like
select top 1 item_name from items where name like 'PO%'
order by number_of_requests_last_week desc
or in a non-MS workd
select iten_name from (
select iten_name from items where name like 'PO%'
order by number_of_requests_last_week desc
) where rownum2
Slashdot Mirror
It's actually more like select top 1 item_name from items where name like 'PO%' order by number_of_requests_last_week desc or in a non-MS workd select iten_name from ( select iten_name from items where name like 'PO%' order by number_of_requests_last_week desc ) where rownum2