Question

SQL 语句Oracle ：select嵌套：

--4.列出COMPUTER 种类中最便宜的图书。 select min(retail),category from books where category='COMPUTER' group by category;怎么把标题列出来

Answer 1

select min(retail) as '价格',category as '书名' from books where category='COMPUTER' group by category

Answer 2

select min(retail) as '价格',category as '类别' from books where category='COMPUTER' group by category 你需要的是中文说明？还是字段名？？