Hi All,
I have a list of entries from users and want mysql to only display entries that are unique.
The mysql statement is as follows
SELECT DISTINCT bids
FROM `tbl_bids`
ORDER BY `bids` ASCOn running the query it is still displaying items that appear more than once.
a table of data looks something like this
id user_id bids
1 1 0.1
2 1 0.2
3 1 0.3
4 2 0.1
5 2 0.2
Im wanting the output to show me, as seen in this table, the value of 0.3, but its listing everything.
Many thanks
Paul
Jump to PostThat is not what distinct does. Distinct will show every value once. What you want is to output the bid that is only once in the table. Something like:
SELECT `bids` FROM `tbl_bids` GROUP BY `bids` HAVING COUNT(1) = 1 ORDER BY `bids` ASC
That is not what distinct does. Distinct will show every value once. What you want is to output the bid that is only once in the table. Something like:
SELECT `bids` FROM `tbl_bids` GROUP BY `bids` HAVING COUNT(1) = 1 ORDER BY `bids` ASC
with your query, it's not just the 0.3 will be displayed, it will also display the 0.1 and 0.2
your recordset will look something like this
0.1
0.2
0.3
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.