-
Hi, all
Now I have a table called XXX. There a two columns A and B. I need the number of rows in which A and B combining together is unique.
I tried this:
SELECT COUNT(DISTINCT(A, B)) FROM XXX;
But i got a error.
How could I get the result?
Thanks in advance.
Alice
-
Try this...
SELECT COUNT(DISTINCT A||B) FROM TABLE;
-
Thanks very much. It is perfect.
Have a good day!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|