MySQL Forums
Forum List  »  Italian

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

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

Written By
L'ordinamento DESC non funziona
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.