查找员工信息 IX(分值:5.00)查找employees表所有emp_no为奇数,且last_name不为Mary的员工信息,并按照hire_date逆序排列CREATE TABLE employees ( emp_no int NOT NULL, birth_date date NOT NULL, first_name varchar(14) NOT NULL, last_name varchar(16) NOT NULL, gender char(1) NOT NULL, hire_date date NOT NULL, PRIMARY KEY (emp_no));输入描述:无输出描述:Emp_no birth_date first_name last_name gender hire_date10011 1953-11-07 Mary Sluis F 1990-01-2210005 1955-01-21 Kyoichi Maliniak M 1989-09-1210007 1957-05-23 Tzvetan Zielinski F 1989-02-1010003 1959-12-03 Parto Bamford M 1986-08-2810001 1953-09-02 Georgi Facello M 1986-06-2610009 1952-04-19 Sumant Peac F 1985-02-18
查找员工信息 IX(分值:5.00)查找employees表所有emp_no为奇数,且last_name不为Mary的员工信息,并按照hire_date逆序排列CREATE TABLE employees ( emp_no int NOT NULL, birth_date date NOT NULL, first_name varchar(14) NOT NULL, last_name varchar(16) NOT NULL, gender char(1) NOT NULL, hire_date date NOT NULL, PRIMARY KEY (emp_no));输入描述:无输出描述:Emp_no birth_date first_name last_name gender hire_date10011 1953-11-07 Mary Sluis F 1990-01-2210005 1955-01-21 Kyoichi Maliniak M 1989-09-1210007 1957-05-23 Tzvetan Zielinski F 1989-02-1010003 1959-12-03 Parto Bamford M 1986-08-2810001 1953-09-02 Georgi Facello M 1986-06-2610009 1952-04-19 Sumant Peac F 1985-02-18
发布时间:2025-07-19 20:23:10