Loading

摘要: https://www.nowcoder.com/practice/ae51e6d057c94f6d891735a48d1c2397?tpId=82&tags=&title=&difficulty=0&judgeStatus=0&rp=1 select salary from salaries wh 阅读全文
posted @ 2022-01-08 20:41 Zhbeii 阅读(55) 评论(0) 推荐(0) 编辑
摘要: https://www.nowcoder.com/practice/6d4a4cff1d58495182f536c548fee1ae?tpId=82&tags=&title=&difficulty=0&judgeStatus=0&rp=1 select a.emp_no,count(*) t fro 阅读全文
posted @ 2022-01-08 18:05 Zhbeii 阅读(45) 评论(0) 推荐(0) 编辑
摘要: https://www.nowcoder.com/practice/6d35b1cd593545ab985a68cd86f28671?tpId=82&tags=&title=&difficulty=0&judgeStatus=0&rp=1 select e.last_name,e.first_nam 阅读全文
posted @ 2022-01-08 17:18 Zhbeii 阅读(40) 评论(0) 推荐(0) 编辑
摘要: https://www.nowcoder.com/practice/c63c5b54d86e4c6d880e4834bfd70c3b?tpId=82&tags=&title=&difficulty=0&judgeStatus=0&rp=1 select s.*, d.dept_no from sal 阅读全文
posted @ 2022-01-08 17:04 Zhbeii 阅读(37) 评论(0) 推荐(0) 编辑
摘要: https://www.nowcoder.com/practice/ec1ca44c62c14ceb990c3c40def1ec6c?tpId=82&tags=&title=&difficulty=0&judgeStatus=0&rp=1 解析:这道题目注意同一时间的去重操作 select * fr 阅读全文
posted @ 2022-01-08 16:40 Zhbeii 阅读(36) 评论(0) 推荐(0) 编辑
摘要: https://www.nowcoder.com/practice/218ae58dfdcd4af195fff264e062138f?tpId=82&&tqId=29753&rp=1&ru=/ta/sql&qru=/ta/sql/question-ranking select * from empl 阅读全文
posted @ 2022-01-08 15:45 Zhbeii 阅读(57) 评论(0) 推荐(0) 编辑