Solved

How to display the different types of results from a Query

Posted on 2016-09-23
2
52 Views
Last Modified: 2016-09-23
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
0
Comment
Question by:Graeme
2 Comments
 
LVL 51

Accepted Solution

by:
Ryan Chong earned 500 total points
ID: 41812050
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
 

Author Closing Comment

by:Graeme
ID: 41812051
Perfect! :)
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question