JOIN with ORDER or MAX()?
7064
Retrieving the last record in each group - MySQL
35057
What is the simplest SQL Query to find the second largest value?
143452
PostgreSQL - fetch the row which has the Max value for a column
126514
Does anyone use Right Outer Joins?
142088
Order of condition execution in MySQL
76298
What is the difference between Left, Right, Outer and Inner Joins?
16178
SQL JOIN - WHERE clause vs. ON clause
23997
How do I order by multiple columns in a SELECT query?
155717
Max of a table/list with indeterminate values
120518
Explanation of self-joins
18626
How does SQL Server order results when joins are used?
55290
join syntax / style performance consideration
59810
sql ORDER BY multiple values in specific order?
66324
Performance of string comparison vs int join in SQL
110895
Get the inverse of a join?
96184
Ordering by the order of values in a SQL IN() clause
148250
mysql query order by multiple items