我能够获取名字和姓氏的组合长度以及按 ID 排序。
但我无法按字典顺序对其进行排序。
SELECT CUSTOMER.ID, CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME
FROM CUSTOMER
WHERE LENGTH(CUSTOMER.FIRST_NAME)+LENGTH(CUSTOMER.LAST_NAME) < 12
ORDER BY CUSTOMER.ID
EXAMPLE
ID first name last name combined length of first name and last name
4 - RUTH HANSON - 10
6 - ANNE HARRIS - 10
但输出应该是
ID first name last name combined length of first name and last name
6 - ANNE HARRIS - 10
4 - RUTH HANSON - 10
简直就是order byFIRST_NAME 和 LAST_NAME 字段
SELECT c.ID, c.FIRST_NAME, c.LAST_NAME
FROM CUSTOMER c
WHERE LENGTH(c.FIRST_NAME)+LENGTH(c.LAST_NAME) < 12
ORDER BY c.FIRST_NAME, c.LAST_NAME
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
