How MySQL Select Max Value
Fetch Row with Max Value On an online shopping website, we'd like to show visitors the most recent items added to the table items, which… Read More »How MySQL Select Max Value
Subquery
How to Resolve ORA-01427: single-row subquery returns more than one row
ORA-01427 There're two error patterns related to ORA-01427 described in this post: SELECT with Equal Operator Job Failed by Trigger. I will talk about them… Read More »How to Resolve ORA-01427: single-row subquery returns more than one row
How to Select Rows Contains Maximum Values
You may notice that, when we selected the maximum value (via MAX()) and with other columns, they looked like in the same row, but in fact,… Read More »How to Select Rows Contains Maximum Values
How to Do Minus in MySQL
In MySQL, there're UNION, UNION ALL set operators like Oracle, but no MINUS. You have to work around it by doing LEFT JOIN tricks.In this… Read More »How to Do Minus in MySQL