I don't really think that you try to understand, its feels like you trying to prove something.
I start to believe the only thing you want is that i agree with your very own opinion. I don't want to prove anything, i want to open your mind for alternative ways solving your problem. At the end it is your own problem and you decide which way to go. But i will always tell my own opinion. And in my opinion your way of solving this problem would not be mine.
artimann wrote:In maria db you cannot use MAX function in select section because you will get syntax error.
really?
https://mariadb.com/kb/en/mariadb/max/artimann wrote:Also you cannot use ORDER before GROUP section - again you will get syntax error. You can try to ORDER inside FROM section (which is work perfect in MYSQL) but you will get wrong row from your db because MARIADB just ignore your sub-query and the result you will get wrong row if you need get last row as first. This is just a piece of things that you cannot do in maria db which is work perfect in MYSQL with INNODB.
Exactly what i said.
https://mariadb.com/kb/en/mariadb/why-i ... y-ignored/Just because MySQL get the expected result does not mean it is clean from SQL standard point of view.
You should never take a look into PostgreSQL, because it is far more SQL standard compliant than MySQL and MariaDB