Title: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following ... Post by: Fattbatts on Feb 9, 2019 Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following is not a valid ANSI SQL command?
• SELECT * FROM EMPLOYEE WHERE Name LIKE 'Ja%'; • SELECT COUNT(*) FROM EMPLOYEE WHERE Salary < 30000; • SELECT HireDate, COUNT(*) FROM EMPLOYEE GROUP BY HireDate; • SELECT HireDate, COUNT(*) FROM EMPLOYEE WHERE Salary < 30000; Title: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following ... Post by: emmamohdisa97 on Feb 9, 2019 Content hidden
|