牛客網sql練習

標籤：nav   table   mysql   records   ace   data   font   coding   local   

一建表語句

/*Navicat MySQL Data TransferSource Server         : testSource Server Version : 50717Source Host           : localhost:3306Source Database       : testTarget Server Type    : MYSQLTarget Server Version : 50717File Encoding         : 65001Date: 2018-03-21 09:49:21*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `employees`-- ----------------------------DROP TABLE IF EXISTS `employees`;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`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ------------------------------ Records of employees-- ----------------------------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‘, ‘1986-08-28‘);INSERT INTO `employees` VALUES (‘10004‘, ‘1954-05-01‘, ‘Chirstian‘, ‘Koblick‘, ‘M‘, ‘1986-12-01‘);INSERT INTO `employees` VALUES (‘10005‘, ‘1955-01-21‘, ‘Kyoichi‘, ‘Maliniak‘, ‘M‘, ‘1989-09-12‘);INSERT INTO `employees` VALUES (‘10006‘, ‘1953-04-20‘, ‘Anneke‘, ‘Preusig‘, ‘F‘, ‘1989-06-02‘);INSERT INTO `employees` VALUES (‘10007‘, ‘1957-05-23‘, ‘Tzvetan‘, ‘Zielinski‘, ‘F‘, ‘1989-02-10‘);INSERT INTO `employees` VALUES (‘10008‘, ‘1958-02-19‘, ‘Saniya‘, ‘Kalloufi‘, ‘M‘, ‘1994-09-15‘);INSERT INTO `employees` VALUES (‘10009‘, ‘1952-04-19‘, ‘Sumant‘, ‘Peac‘, ‘F‘, ‘1985-02-18‘);INSERT INTO `employees` VALUES (‘10010‘, ‘1963-06-01‘, ‘Duangkaew‘, ‘Piveteau‘, ‘F‘, ‘1989-08-24‘);INSERT INTO `employees` VALUES (‘10011‘, ‘1953-11-07‘, ‘Mary‘, ‘Sluis‘, ‘F‘, ‘1990-01-22‘);

1 尋找最晚入職員工的所有資訊

 

牛客網sql練習