ansaurus

Question

Answer 1

+3 A:

Try this:

SELECT c1, COUNT(*)
FROM T1
GROUP BY c1
HAVING COUNT(*) > 1

Mark Byers 2010-08-20 13:58:14

Answer 2

+1 A:

SELECT c1, count(*) FROM T1 GROUP BY c1 HAVING count(*) > 1

canni 2010-08-20 13:58:35

yep i notices this after submitting answer, corected

canni 2010-08-20 14:00:29

Answer 3

+2 A:

SELECT
    'a',
    2
UNION ALL
SELECT
    'b',
    3

Tom H. 2010-08-20 14:33:30

If a table T1 has single column c1 with data base (a,a,b,b,b,c)