-8

Hello I'm quite new to mysql i have a table containing 2 columns and 3 rows. the columns are known as ROWNUM and LATITUDE. Can anyone suggest a query i could use to display all the rows that have a specified value in LATITUDE column. for example :

ROWNUM | LATITUDE
1      |   35.8
2      |   35.8
3      |  -23.5

I would like to display at the end of this the rows containing 35.8 in the LATITUDE COLUMN e.g:

1 | 35.8
2 | 35.8.
2
  • 1
    Seriously? This is like 101 select statement. Google, you know the search engine? Commented Feb 26, 2017 at 22:29
  • 1
    Please stop shouting Commented Feb 26, 2017 at 22:30

1 Answer 1

2

Use a WHERE statement to filter records with an specific LATITUDE.

SELECT ROWNUM, LATITUDE
FROM   YOUR_TABLE
WHERE  LATITUDE = 35.8
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks it worked brilliantly

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.