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;