SELECT name FROM Aircraft ORDER BY distance LIMIT 3
What are the aircrafts with top 3 shortest lengthes? List their names.
SELECT name FROM Aircraft ORDER BY distance LIMIT 3
select name from aircraft order by distance limit value
What are the aircrafts with top 3 shortest lengthes ? List their names .