LintCode MySQL 1918. 第二高的球员的身高

1. 题目

编写一个 SQL 语句，获取球员 (players) 表中第二高的身高 (height)

表定义: players (球员表)

https://www.lintcode.com/problem/1918

2. 解题

• if(a,b,c), a true，执行 b， 否则 c

-- Write your SQL Query here --
-- example: SELECT * FROM XX_TABLE WHERE XXX --
select
(
    if(
        (select count(*) from (select distinct height from players) p) >= 2,
        (select distinct height from players order by height desc limit 1 offset 1),
        NULL
    )
) second_height

---

我的CSDN博客地址 https://michael.blog.csdn.net/

长按或扫码关注我的公众号（Michael阿明），一起加油、一起学习进步！