How to query the maximum value field in MySQL

The method for querying the maximum value in MySQL is not very complex. The following describes how to query the maximum value in MySQL. If you have encountered the problem of querying the maximum value field in MySQL, take a look.

 
 

  
  
select a.*, b.count from (  
  
  
select * from message  
  
  
where to_uid=2026 and is_del<2 and from_uid>0  
  
  
 
  
  
order by mid desc  
  
  
)   
  
  
as a  
  
  
join  
  
  
(  
  
  
select reply_id,count(*) as count from message  
  
  
where reply_id>0  
  
  
group by reply_id  
  
  
)  
  
  
as b  
  
  
on (a.reply_id=b.reply_id)  
  
  
 
  
  
group by a.reply_id  
  
  
order by a.mid desc  
  
  
 
  
  
 
 
 

MySQL query results are sorted by a certain value

Use functions to query row numbers in MySQL

Non-empty question in MySQL Query

Troubleshooting of MySQL query timeout

MySQL Date and Time Functions