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 vote125 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote120 views1 answer
Sqlplus change user
SQL
0 vote120 views1 answer
How to find sql server name
SQL
2 votes125 views1 answer
Mysql change data type of column
SQL
0 vote127 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote110 views1 answer
Oracle free up space in tablespace
SQL
0 vote234 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote157 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote112 views2 answers
Mysql output csv
SQL
0 vote114 views1 answer
Set default value now() date
SQL