![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
春风沂水
这个作者很懒,什么都没留下…
展开
-
SQL入门的问题(1)
1.连接SQLmysql -uroot -p2.创建数据库create database python3 charset=utf8;3.显示数据库 show databases;4.切换到当前数据库use python3;原创 2017-10-10 15:46:21 · 235 阅读 · 0 评论 -
leetcode 2--Second Highest Salary
https://leetcode.com/problems/second-highest-salary/description/Write a SQL query to get the second highest salary from the Employee table. +—-+——–+ | Id | Salary | +—-+——–+ | 1 | 100 | | 2原创 2018-01-26 19:55:50 · 143 阅读 · 0 评论 -
sql练习题2
31、查询所有教师和同学的name、sex和birthday.select students.sname,students.ssex,students.sbirthday,teachers.TNAME,teachers.TSEX,teachers.TBIRTHDAY from students inner join teachersSELECT Sname,Ssex,Sbirthday原创 2018-01-20 13:19:31 · 693 阅读 · 0 评论