SELECT flno FROM Flight ORDER BY distance ASC LIMIT 3
What are the numbers of the shortest flights?
SELECT flno FROM Flight ORDER BY distance ASC LIMIT 3
select flno from flight order by distance asc limit value
What are the numbers of the shortest flights ?