🔒 Closed Select max date for each type for each employee

[Phcmjal]

eto tngnan mo eto output nito

SELECT employee.emp_id,type,date,amount FROM employee
INNER JOIN
(
SELECT MAX(emp_id) as emp_id FROM employee GROUP BY type,empid
)as tb ON tb.emp_id = employee.emp_id where empid =1




ikaw na bahala mag bago mag aad ka ng empid sa field kasi wala ka primary key ung emp_id naka auto increment yan

tapos na problem mo

 

[Phcmjal]

ung emp_id kaya ganan number kasi naka auto number yan gusto mo mag add ka ng bagong field as empid