php - 如何按降序对 id 和 sub_id 进行排序？

Question

我的 table 就像...

id  Sub_id  name    path    date

1   33  Sanjay  Something here to all   Some thing
2   33  Sanjay      
3   34  Fariya      
4   35  Neeraj      
5   35  Neeraj      
6   32  Mukesh      
7   37  Ravi        
8   32  Mukesh      
9   32  Mukesh      
10  32  Mukesh      

当我使用这个查询时——表名是 gallery...

$sql="select * from (select * from gallery order by id desc 4) gallery group by Sub_id desc limit 4";

我需要这种格式

id  Sub_id  name    path    date
10  32  Mukesh  Something here to all   Some thing
7   37  Ravi        
5   35  Neeraj      
3   34  Fariya      

请帮帮我...

Answer 1

以您的原始 SQL 为基础(如果您想先对 id 然后对 sub_id 进行排序):

$sql="select * from gallery group by sub_id order by id desc, subid desc limit 0,4";

如果不是为了消除“重复”，那么可以用下面的sql代替上面的sql:

$sql="select * from gallery order by id desc, subid desc limit 0,4";