Question

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

编写一个查询是SQL脚本，要求是返回telephone的倒数第二位是“9”的，并且address里包含“余杭”的客户列表。同时对查询出来的结果集进行按照id编号进行倒序排列。
数据表是Client。

Answer 1

select * from Client where address like '%余厅州杭%'余裂 and telephone like '扮毁蔽%9_' order by id desc

Answer 2

select * from Client c where c.telephone like '%9_'漏纳闹 and c.address like '茄缓%余返罩杭%' ordery by c.id desc;