SQL 查询中的排序依据

Question

我需要选择不同的vehicle.model行并按rate.day值对它们进行排序。 请帮忙查询一下吗？

感谢您考虑我的问题。

Answer 1

select distinct model, day_rate from vehicle
  inner join rate on vehicle.vehicle_type = rate.vehicle_type
  order by day_rate

现在。快去交作业吧...

Answer 2

select distinct v.model
from vehicle v
inner join rate r
on v.vehicle_type = r.vehicle_type
order by r.day_rate

Answer 3

SELECT 
    v.model
FROM 
    vehicle v
  JOIN
    rate r
      ON r.vehicle_type = v.vehicle_type
ORDER BY r.day_rate 

或更好：

SELECT  
    model
FROM 
    vehicle v
GROUP BY 
    model
ORDER BY 
    ( SELECT 
          r.day_rate
      FROM 
          rate r
      WHERE 
          r.vehicle_type = MIN(v.vehicle_type) 
    )