MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Order By in FROM Subquery doesn't work in 5.7
Posted by: Peter Brawley
Date: April 19, 2016 08:00AM

> you can see , the 'ORDER BY `Flightdate` DESC' in mysql 5.7 has been ignored .

Already explained: that Order By clause is inside the join, and will be overriddden by the outer query's Group By and Order By clauses.

Again, if there is a problem with the result, post the result of ...

Show Create Table flightontime;

... and enough Insert statements to reproduce the result problem in 5.7.

Until we have that info, we're spinning our wheels.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 15, 2016 05:28AM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 15, 2016 10:24AM
Re: Order By in FROM Subquery doesn't work in 5.7
Rick James
April 15, 2016 03:38PM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 16, 2016 12:21AM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 16, 2016 10:08AM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 17, 2016 12:54AM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 17, 2016 04:28AM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 18, 2016 10:43PM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 19, 2016 08:00AM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 20, 2016 01:28AM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 20, 2016 02:13AM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 20, 2016 11:00AM
Re: Order By in FROM Subquery doesn't work in 5.7
Rick James
April 20, 2016 11:41PM
Re: Order By in FROM Subquery doesn't work in 5.7
zhiren Yip
April 22, 2016 04:03AM
Re: Order By in FROM Subquery doesn't work in 5.7
Aanya Dsouza
April 21, 2016 03:26AM
Re: Order By in FROM Subquery doesn't work in 5.7
Rick James
April 18, 2016 10:52PM
Re: Order By in FROM Subquery doesn't work in 5.7
Peter Brawley
April 19, 2016 07:55AM
Re: Order By in FROM Subquery doesn't work in 5.7
Mohammed Bilo
April 21, 2016 03:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.