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 vote237 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
2 votes258 views2 answers
How to check data type in sql server
SQL
0 vote243 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
7 votes241 views1 answer
Forge server hosting
SQL
0 vote261 views2 answers
Athena drop partition
SQL
0 vote259 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote266 views1 answer
Psql get table data types
SQL
10 votes235 views3 answers
Sql limit results
SQL
1 vote270 views1 answer
Key validation sql
SQL
0 vote255 views1 answer
User, group, or role 'open' already exists in the current database.
SQL