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 votes186 views3 answers
Mysql list tables by size
SQL
3 votes178 views3 answers
Mysqldump: couldn
SQL
0 vote223 views1 answer
Oracle current date minus 1 day
SQL
0 vote201 views1 answer
Oracle date summer time
SQL
49 votes255 views6 answers
Get duplicate records in sql
SQL
0 vote161 views1 answer
Myswql show full processlist
SQL
0 vote172 views1 answer
Mysql query to add hours to column in table
SQL
4 votes157 views3 answers
Copy table postgres
SQL
3 votes162 views2 answers
Mysql create database
SQL
5 votes251 views4 answers
Sql check
SQL