How to display the different types of results from a Query

Hi all, I have a query that I want to get a specific result from:
SELECT * FROM tickets WHERE ticket_from>Now() AND ticket_live=TRUE AND ticket_soldout=FALSE

Open in new window


there is a field in this table called ticket_curr

I want to display each different value of ticket_curr (not count or multiples of the same)

result I would like is:

EUR,AUD,GBP,SGD,etc

Open in new window


Cheers
Graemewebber4technologiesAsked:
Who is Participating?
 
Ryan ChongConnect With a Mentor Commented:
is this result you want?
SELECT ticket_curr
FROM tickets WHERE ticket_from>Now() AND ticket_live=TRUE AND ticket_soldout=FALSE
Group By ticket_curr
Order By ticket_curr

Open in new window

1
 
Graemewebber4technologiesAuthor Commented:
Perfect! :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.