SQL-15 查找employees表所有emp_no为奇数，且last_name不为Mary的员工信息，并按照hire_date逆序排列...

- 日理万妓 2022-01-09 15:51 90阅读 0赞

## 题目描述 ##

查找employees表所有emp\_no为奇数，且last\_name不为Mary的员工信息，并按照hire\_date逆序排列  
CREATE TABLE \`employees\` (  
\`emp\_no\` int(11) 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\`));

## 输入描述: ##

无

## 输出描述: ##

<table> 
 <tbody> 
  <tr> 
   <th>emp_no</th> 
   <th>birth_date</th> 
   <th>first_name</th> 
   <th>last_name</th> 
   <th>gender</th> 
   <th>hire_date</th> 
  </tr> 
 </tbody> 
 <tbody> 
  <tr> 
   <td>10011</td> 
   <td>1953-11-07</td> 
   <td>Mary</td> 
   <td>Sluis</td> 
   <td>F</td> 
   <td>1990-01-22</td> 
  </tr> 
  <tr> 
   <td>10005</td> 
   <td>1955-01-21</td> 
   <td>Kyoichi</td> 
   <td>Maliniak</td> 
   <td>M</td> 
   <td>1989-09-12</td> 
  </tr> 
  <tr> 
   <td>10007</td> 
   <td>1957-05-23</td> 
   <td>Tzvetan</td> 
   <td>Zielinski</td> 
   <td>F</td> 
   <td>1989-02-10</td> 
  </tr> 
  <tr> 
   <td>10003</td> 
   <td>1959-12-03</td> 
   <td>Parto</td> 
   <td>Bamford</td> 
   <td>M</td> 
   <td>1986-08-28</td> 
  </tr> 
  <tr> 
   <td>10001</td> 
   <td>1953-09-02</td> 
   <td>Georgi</td> 
   <td>Facello</td> 
   <td>M</td> 
   <td>1986-06-26</td> 
  </tr> 
  <tr> 
   <td>10009</td> 
   <td>1952-04-19</td> 
   <td>Sumant</td> 
   <td>Peac</td> 
   <td>F</td> 
   <td>1985-02-18&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

SQL:

select * from employees
    where emp_no%2!=0 and last_name!='Mary'
    order by hire_date desc

转载于:https://www.cnblogs.com/kexiblog/p/10668541.html