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
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
Attachments
-
You do not have permission to view the full content of this post. Log in or register now.
Last edited: