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

1 vote117 views1 answer
Xampp import sql file command line
SQL
16 votes126 views6 answers
Mysql find duplicates in same table
SQL
0 vote113 views1 answer
Ora 00001 error catch plsql
SQL
18 votes87 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote129 views1 answer
Get create table query existing table mysql
SQL
0 vote126 views1 answer
Rename view mysql
SQL
0 vote167 views1 answer
Sql select without column name
SQL
0 vote72 views0 answer
SQL
1 vote122 views1 answer
How to change owner in postgres
SQL
0 vote121 views1 answer
Change filed order in mysql
SQL