Basic SQL retrieve list of items without counting it twice

Question

I have a travel log, I am trying to display a list of cities visited during a day

 id  day cityvisited user
  1   1        2        4  
  1   1        6        3
  1   1        4        10
  1   1        4        6

SELECT cityvisited FROM cv WHERE day = 1

returns the data 2, 6, 4, 4

Can I get it so it just returns 2, 6, 4

possible duplicate of [How to select unique records by SQL](http://stackoverflow.com/questions/1641718/how-to-select-unique-records-by-sql) — FuzzyTree, Jun 15 '14 at 01:16

score 4 · Accepted Answer · answered Jun 15 '14 at 00:49

4

SELECT DISTINCT cityvisited FROM cv WHERE day = 1

should do it.

answered Jun 15 '14 at 00:49

VBlades

2,241
1
12
8

score 0 · Answer 2 · answered Jun 15 '14 at 00:51

0

Which SQL you are using ?

If you are using SQL Server then you can use

 SELECT distinct cityvisited FROM cv WHERE day = 1

It works for many other DB as well.

Hope this help you.

answered Jun 15 '14 at 00:51

dotnetstep

17,065
5
54
72

score 0 · Answer 3 · answered Jun 15 '14 at 00:54

0

Select distinct cityvisited from cv where day = 1

will work in tsql.

if your using a different type of sql and distinct doesnt work you could just add group by cityvisited to your query

answered Jun 15 '14 at 00:54

Dannyg9090

196
8

Basic SQL retrieve list of items without counting it twice

3 Answers3