Advertisement

每日两题(1),一起交流~

阅读量:

1.题目描述

检索所有关于最后入职员工的详细资料

复制代码
 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`));
    
    
    
    
复制代码
 INSERT INTO employees VALUES(10001,'1953-09-02','Georgi','Facello','M','1986-06-26');

    
 INSERT INTO employees VALUES(10002,'1964-06-02','Bezalel','Simmel','F','1985-11-21');
    
 INSERT INTO employees VALUES(10003,'1959-12-03','Parto','Bamford','M','198

全部评论 (0)

还没有任何评论哟~