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

2 votes224 views1 answer
Sql view column data type
SQL
-1 vote286 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
-1 vote270 views1 answer
Mysql #1064 error
SQL
1 vote292 views1 answer
Sql where max date
SQL
-1 vote285 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote313 views2 answers
Postgres isnull
SQL
0 vote270 views1 answer
How to export only procedures mysql
SQL
1 vote283 views1 answer
Age postgres
SQL
0 vote273 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
3 votes273 views1 answer
Créer une table sql
SQL