|
Title: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following ... Post by: killak on Feb 9, 2019 Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter "S" using standard SQL?
• SELECT * FROM EMPLOYEE WHERE Name IN ['S']; • SELECT EmpNo FROM EMPLOYEE WHERE Name LIKE 'S'; • SELECT * FROM Name WHERE EMPLOYEE LIKE 'S*'; • SELECT * FROM EMPLOYEE WHERE Name LIKE 'S%'; Title: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following ... Post by: UnRaquel on Feb 9, 2019 SELECT *
FROM EMPLOYEE WHERE Name LIKE 'S%'; Title: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following ... Post by: killak on Feb 9, 2019 Good timing, thanks!
|