sql
爱吃袜子的二哈
这个作者很懒,什么都没留下…
展开
-
Sql语句将0,1转化为男女性别
SELECT id, phone, name,CASE gender WHEN '1' THEN '男' WHEN '2' THEN '女' END AS gender, start_city, end_city, story, create_time FROM active_collection_story;原创 2019-01-25 14:34:11 · 10259 阅读 · 0 评论 -
查询每年成绩前三名的学生
创建表:CREATE TABLE `test` ( `id` int(11) NOT NULL, `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `score` int(255) DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEF...原创 2019-04-10 17:00:59 · 650 阅读 · 0 评论 -
sql去重查询
select distinct(user_id) FROM activity_third_coupon where type = 'qunarSendCoupon';select * from activity_third_coupon where id in (select max(id) from activity_third_coupon group by user_id) and ty...原创 2019-06-14 19:48:17 · 12355 阅读 · 0 评论