- 博客(4)
- 收藏
- 关注
RSS订阅原创 sqlzoo练习题（3.SELECT from Nobel Tutorial）14题中，order by subject IN (‘Chemistry‘,‘Physics‘)用法解惑整理笔记
题库链接：SELECT from Nobel Tutorial - SQLZOO 原题如下： 14.The expression subject IN ('Chemistry','Physics') can be used as a value - it will be 0 or 1. Show the 1984 winners and subject ordered by subject and winner name; but list Chemistry and Physics last. 解
2022-05-25 11:14:28
1161
原创 sql练习题答案2（sqlzoo-3.SELECT from Nobel Tutorial 8-14题）
零基础学sql，sqlzoo练习题SELECT from Nobel Tutorial - SQLZOO 8.Show the year, subject, and name of Physics winners for 1980 together with the Chemistry winners for 1984. select yr,subject,winner from nobel where (yr='1980' and subject='physics') or (yr='1984' a
2022-05-24 14:36:14
364
1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人