0
SQL - MIN Question
Why the following is wrong? SELECT firstname, lastname, MIN(salary) AS salary FROM employees; When I ran it, it indicates: ERROR: column "employees.firstname" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT firstname, lastname, MIN(salary) AS salary FROM emplo...
1 Odpowiedź
+ 2
if you write select list ,but you don’t write firstname,lastname,Min(Salary),i think it will be right .
you understand?