Select one field from query with subquery

Question

I am using the MySQL query to find distance between tow zip-codes when lat long is given.

SELECT postcode, ( 3959 * acos( cos( radians( 52.47592 ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( -1.90539 ) ) + sin( radians( 52.47592 ) ) * sin( radians( latitude ) ) ) ) AS distance FROM ukpostcodes  HAVING distance <= 5 ORDER BY distance

it is working fine. But I want only postcode in result. I don't want distance column in result .

How can I achieve it.

Thanks

Héctor E · Accepted Answer · 2015-08-01 12:25:13Z

1

SELECT postcode FROM(
SELECT postcode, ( 3959 * acos( cos( radians( 52.47592 ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( -1.90539 ) ) + sin( radians( 52.47592 ) ) * sin( radians( latitude ) ) ) ) AS distance FROM ukpostcodes  HAVING distance <= 5 ORDER BY distance
) AS tbl

edited Aug 1, 2015 at 12:25

answered Aug 1, 2015 at 12:02

Héctor E

4363 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Rich5757 Over a year ago

Thanks much. But I run this query it is showing this error . Every derived table must have its own alias.

Raging Bull Over a year ago

@Rich5757: Give a name to the subquery. Something like as tbl at the very end of the query.

Raging Bull Over a year ago

Just tbl. No need of double quotes.

Héctor E Over a year ago

@Raging-Bull: True that

Collectives™ on Stack Overflow

Select one field from query with subquery

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related