Warm tip: This article is reproduced from serverfault.com, please click

sql-显示最昂贵电影的成本在2美元以内的查询

(sql - A query that shows the cost within $2 of the most expensive film)

发布于 2020-12-04 07:35:28
TITLE   GEN DURATION    PRODUCTION_YEAR MED PURCHASE_PRICE  PURCHASE_   MOVIE_ID

那是我的专栏

我正在使用oracle 9i

感谢任何能提供帮助的人

Questioner
nick
Viewed
0
Popeye 2020-12-04 18:37:55

你可以MAX在子查询中的inWHERE子句中使用该函数,如下所示:

SELECT * FROM MOVIE
 WHERE PURCHASE_PRICE >= (SELECT MAX(PURCHASE_PRICE) - 2 FROM MOVIE)