Jump to content

Archived

This topic is now archived and is closed to further replies.

thejayjay

easy distinct question

Recommended Posts

i want to select some additional fields from my table, but they don\'t need to be distinct. how do i do that?

Share this post


Link to post
Share on other sites

Well, it is not possible in a single query to get distinct values from one coloumn (field) and multiple hits from another coloumn.

 

If that is what you want you must make a subselect which is not directly possible, but you may use temporary tables (see other threads).

 

An alternative is to get the not-distinct results and then parse the coloumn you want to be distinct, i.e. sort the rows on the coloumn you want to be distinct and then only grab unique values from this coloumn.

 

Another alternative is to return distinct values first, then for each distinct value do a non-distinct query with this value in the WHERE clause (again using php or perl or some other language).

 

Of all of the above I like temporary tables most or the parsing solution, since several sql queries might be quite slow.

 

If you want us to be more detailed then you should post a more detailed description of your tables, fields and so on. Including your current sql query!

 

I hope this will get you further,

P., denmark

Share this post


Link to post
Share on other sites

that was the answer that i was looking for and was pretty much what i had determined from looking for information online.

 

thanks for clearing it up for me!

 

cheers,

james

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.