end_date minust start_date column gives duration.
if durationn for multiple projects same then i have to order by start date rather than just oder by duration. how to achieve this
select start_date, end_date,(end_date-start_date) as duration order by duration ( how to add here order by start_date?? if duration for say project1 and project 2 and project 3 out of 100 projects is same say 20 days)