选择所有数据，但按最新日期时间和当前城市显示最佳数据 [英] Select all data but show top by latest datetime and current city wise

问题描述

假设用户正在从kolkata查找网站，如果用户搜索内容，则数据将按最新日期时间和当前城市kolkata（当前地点）显示。



我尝试了什么：



我尝试过多个订单条款的选择查询



从日期desc，city desc，div desc

Suppose User is looking a website from kolkata and If user search the content then data will appear by latest datetime wise and by current city kolkata(Current Place).

What I have tried:

I have tried select query with multiple order by clause

select * from TABLE order by date desc, city desc

推荐答案

中选择*来试试这个

try this

select * , 'key' = 'a' from city where CityName = 'kolkata'   
union all
select * ,'key' = 'b' from city where CityName <> 'kolkata'  order by 'key', DateColumn desc 

这篇关于选择所有数据，但按最新日期时间和当前城市显示最佳数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！