我只需要按查询分组一个表,使用group by
查询只显示最新记录我想按手机号码分组
我的列名如下:
Reservation_id
、Client_name
、Email_address
、Mobile_number
、Vehical_type
所以我想按此列分组并显示最新记录
我尝试了这个查询:
SELECT `Reservation_id`,`Client_name`,`Email_address`,`Mobile_number`
FROM `car_reservation` GROUP BY `Mobile_number` ASC
ORDER BY `Reservation_id` ASC;
这是最后一个QUERY SELECT Reservation_id,Client_name,Email_address,Mobile_number,Pickup_date_time,Pickup_address,Drop_off_address,Distance,Total_price,Vehical_type
FROM car_reservation
WHERE Reservation_id IN (
SELECT MAX(Reservation_id)
FROM car_reservation
GROUP BY Mobile_number
ORDER BY Reservation_id desc
) ORDER BY Reservation_id DESC
SELECT Reservation_id,Client_name,Email_address,Mobile_number FROM car_reservation WHERE Mobile_number in (SELECT Mobile_number FROM car_reservation ORDER BY Reservation_id ASC LIMIT 0,1);
我希望这是你所期望的。
试试这个。。
$sql = "SELECT `Reservation_id`,`Client_name`,`Email_address`,`Mobile_number`
FROM car_reservation GROUP BY Mobile_number ASC ORDER BY Reservation_id ASC LIMIT 1";