Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP PROCEDURE IF EXISTS `negyveneve`;
- DELIMITER //
- CREATE PROCEDURE negyveneve ()
- READS SQL DATA
- BEGIN
- SELECT CONCAT(`FIRST_NAME`,' ', `LAST_NAME`) AS 'FULLNAME' FROM `employees` WHERE FLOOR(DATEDIFF(CURRENT_DATE,`HIRE_DATE`)/365.25) < FLOOR(DATEDIFF(CURRENT_DATE,DATE_ADD(CURRENT_DATE,INTERVAL -40 YEAR))/365.25);
- END//
- DELIMITER ;
- CALL negyveneve();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement