如何实现SQL查询,以便在以下Java类中按姓氏升序排序选择所有员工:
public class SqlQueries {
//Select all employees sorted by last name in ascending order
//language=HSQLDB
String select = "";
}
如果有一个单独的列的姓氏,那么很容易实现
SELECT * FROM EMPLOYEE ORDER BY LAST_NAME ASC;
如果只有一列,即全名,则从最后一个空白中分割字符串并提取姓氏。
SELECT * FROM EMPLOYEE ORDER BY SUBSTR(FULL_NAME,INSTR(FULL_NAME,' ',-1)) ASC;