MySQL Forums
Forum List  »  Italian

L'ordinamento DESC non funziona
Posted by: Fabrizio Bartolomucci
Date: June 07, 2024 01:42AM

Salve,
sto provando a invertire la sequenza dell'output di una query con ASC, ma continua sempre a presentarmi i risultati in ordine decrescente.
Questa la query:

SELECT *, ( 3959 * acos ( cos ( radians(38.764086) ) * cos( radians(latitude ) ) * cos( radians(longitude ) - radians(16.199074) ) + sin ( radians(38.764086) ) * sin( radians(latitude ) ) ) ) AS distance FROM banner HAVING distance < 0.3 ORDER BY 'index' ASC

Nulla cambia se metto DESC.

Cosa ho sbagliato?

Grazie, Fabrizio

Options: ReplyQuote


Subject
Views
Written By
Posted
L'ordinamento DESC non funziona
266
June 07, 2024 01:42AM


Sorry, only registered users may post in this forum.

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.