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 vote144 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote143 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
1 vote163 views1 answer
Show per page table in xampp
SQL
4 votes235 views4 answers
Update select mysql
SQL
0 vote180 views1 answer
Mysql equivalent decode oracle
SQL
0 vote143 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote139 views1 answer
Sql clear table
SQL
0 vote139 views1 answer
Mysql add comment to column
SQL
3 votes148 views1 answer
How to check schema privileges in oracle
SQL
2 votes186 views2 answers
Mysql search for column name in all tables
SQL