Mysql query ??????????

szms

Here is data tables in mysql;

Function_ID | Domain_ID | Order_No |
+-------------+-----------+----------+
| 1 | 3 | 1 |
| 2 | 6 | 1 |
| 3 | 4 | 1 |
| 5 | 4 | 1 |
| 6 | 6 | 1 |
| 7 | 4 | 1 |
| 8 | 5 | 1 |
| 10 | 3 | 1 |
| 11 | 3 | 1 |
| 12 | 3 | 1 |
| 13 | 3 | 1 |
| 14 | 4 | 1 |
| 15 | 6 | 1 |
| 16 | 5 | 1 |
| 17 | 5 | 1 |
| 18 | 4 | 1 |
| 3 | 3 | 2 |
| 5 | 3 | 2 |
| 6 | 6 | 2 |
| 7 | 3 | 2 |
| 10 | 2 | 2 |
| 13 | 3 | 2 |
| 14 | 3 | 2 |
| 15 | 2 | 2 |
| 16 | 3 | 2 |
| 18 | 3 | 2 |
| 13 | 3 | 3 |
| 15 | 4 | 3 |
+-------------+-----------+----------

I am looking for a query which will give the the single ocuurence of the Function_ID, i.e.
Function_ID | Domain_ID | Order_No |
| 1 | 3 | 1 |
| 2 | 6 | 1 |
| 8 | 5 | 1 |
| 11 | 3 | 1 |

and so on.

Can you tell me the query?

DeltaRho2K

SELECT * FROM table_name GROUP BY Function_ID

This may or may not be what you are looking for, because I need a bit more details as to exactly what you are wanting to do, but it's a start in finding out where we need to go from here.

szms

I want all unique Function_ID that appears in the tables only once.

DeltaRho2K

Then what I gave you earlier should work, or you can use a distinct select query... The GROUP BY should be all you need since DISTINCT is converted to a GROUP BY on all columns anyhow, but here is the basic syntax fr the DISTINCT option.

SELECT DISTINCT Function_ID, Domain_ID, Order_NO FROM table_name

incidentally, you can go to http://www.mysql.com and you should be able to find what you are looking for in the manual.

BlueMeteor

Do you want this?

SELECT * FROM table_name GROUP BY Function_ID having count(*)=1

hth