s****s
发帖数: 42 | 1 List the serial number of the car which has the shortest life span.
My code like this:
select serialno, min(lifespan)
from
(select d.serialno as serialno,
(d.ddate - c.pyear) as lifespan
from destruction d, car c
where d.serialno = c.serialno)
result
group by serialno;
It displayed the following table, but the query required to only display the
third row. How to make it?
SERIALNO MIN(LIFESPAN) |
|
