Using GROUP BY in MySQL Join Table

SELECT q.* FROM (
SELECT patient . * , visit.uid AS visit_uid
FROM patient
LEFT JOIN visit ON patient.uid = visit.patient_id
ORDER BY visit_uid DESC 

) q GROUP BY q.uid ORDER BY q.visit_uid DESC 

LIMIT 0 , 10

Source: stackoverflow.com

Similar codes

0 vote191 views1 answer
Myswql show full processlist
SQL
0 vote236 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote201 views1 answer
Sql column contains special character
SQL
16 votes213 views2 answers
Oracle ddl
SQL
2 votes187 views1 answer
Sql server find table name
SQL
3 votes217 views1 answer
Oracle undo tablespace schema
SQL
0 vote200 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote147 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote210 views1 answer
Pass array parameter to stored procedure c#
SQL
1 vote188 views1 answer
How to delete data from sql database in android
SQL