Question:
Minimum Travel Time
Display schedule_id, source, destination and travel_time which has minimum travel time. Sort the result based on schedule id
Code:
Main.sql
select schedule_id, source, destination, duration from schedule where duration=(select min(duration) from schedule) order by 1;
Remarkable! Its genuinely awesome piece of writing, I have got much clear idea on the topic of from this post.