查找今天過生日的同學(xué)

這里表中已經(jīng)存儲(chǔ)了生日，所以思路是取出date_birth去今天的日期相比較

SELECT NAME,date_birth FROM org_mhi_studentfiles WHERE MID(date_birth,6,5) = MID(CURDATE(),6,5);
-- or
SELECT NAME,date_birth FROM org_mhi_studentfiles WHERE MID(date_birth,6,5) = DATE_FORMAT(NOW(),'%m-%d');

最年輕的同學(xué)

SELECT NAME,date_birth FROM org_mhi_studentfiles WHERE date_birth = (SELECT MAX(date_birth) FROM org_mhi_studentfiles);
-- or
SELECT NAME,date_birth FROM org_mhi_studentfiles ORDER BY date_birth DESC LIMIT 0,1;

• limit 語法

limit 開始行,行數(shù)
limit 行數(shù)

• limit 和offset

-- 從第一行開始，取三行
limit 0,3
limit 3 offset 0

-- 例如： 
SELECT NAME,date_birth FROM org_mhi_studentfiles ORDER BY date_birth DESC LIMIT 0,3;
 
SELECT NAME,date_birth FROM org_mhi_studentfiles ORDER BY date_birth DESC LIMIT 3 OFFSET 0;

結(jié)果都是：

生日倒數(shù)排名第三

這里有一個(gè)重復(fù)值

SELECT NAME,date_birth FROM org_mhi_studentfiles  WHERE date_birth = 
(SELECT  DISTINCT date_birth FROM org_mhi_studentfiles ORDER BY date_birth DESC LIMIT 2,1);

結(jié)果：