SQL: how to only use dynamic column for order, not as part of result set

I currently have a query that returns a list of columns, and one of those columns I only want to use internally as a sort column, not as a column in the result set.

  SELECT Id, Lat, Lng开发者_如何学运维, <haversine calc> as Distance
    FROM Locations
ORDER BY Distance

Based on the above, the only reason I currently include 'Distance' in the the SELECT clause is so I can use it in the ORDER BY clause. My consumer code doesn't use Distance at all.

How can I rewrite this query to only return the columns I'm interested in (Id, Lat, Lng) and not the ones I'm not interested in (Distance), while allowing the sort on Distance?

All you have to do is to move your calculation into your ORDER BY clause like this:

SELECT Id, Lat, Lng
FROM Locations
ORDER BY <haversine calc>

You don't need to include a column in select cause you want to sort on it. You can directly query the cols you want

SELECT Id, Lat, Lng FROM Locations ORDER BY <Your Col>