- 如何处理SQL的多次排序?
题目:List the winners, year and subject where the winner starts with Sir. Show the the most recent first, then by name order.
题目中,最终列表需要先以年份排序,再以名字排序,存在两层排序顺序
select winner,yr,subject
from nobel
where winner like 'Sir%'
order by yr desc ,winner
- round函数:用于把数值字段舍入为指定的小数位数。
SELECT ROUND(column_name,decimals)
FROM table_name
- concat函数:将多个字符串连接为一个字符串
CONCAT(str1,str2.