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

4 votes313 views1 answer
Sql select limit range
SQL
2 votes276 views2 answers
Mysql get time from datetime
SQL
0 vote275 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote302 views1 answer
View psql output in horizontal scrolling
SQL
3 votes273 views1 answer
Mysql load sql from file
SQL
7 votes285 views1 answer
Oracle reset sequence
SQL
0 vote295 views1 answer
Get enginge db mysql
SQL
0 vote292 views1 answer
Mysql root localhost run
SQL
3 votes263 views4 answers
Show sql server database
SQL
0 vote318 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL