SQL语句实现一个查询,并排序。

2024-12-01 17:11:05
推荐回答(2个)
回答1:

select * from Client where address like '%余杭%' and telephone like '%9_' order by id desc

回答2:

select * from Client c where c.telephone like '%9_' and c.address like '%余杭%' ordery by c.id desc;