Check duplicate names in SQL server table

Nanda Kishore Chandrapati

9y891

Hi all,

i have below table like this.

id name class

1 A null

2 B null

3 c null

4 d null

1 A 9

3 c 9

how to check data with bit value is exist or not. i need below output.

i tried this... but not working

SELECT Id,name,class

(case when isnull(class,123)=123 then 0 else 1 end) as exist

FROM test_Table.

i need below output

id name class exist

1 A null 0

2 B null 0

3 c null 0

4 d null 0

1 A 9 1

3 c 9 1

regards

Kishore

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp9y ago
Hi,

Please try below query -
SELECT id,name,class,CASE WHEN rank=1 THEN 0 ELSE 1 END AS EXIST FROM(
SELECT id,name,class,rank() OVER(partition by name order by id asc) AS rank FROM tablename)e
Amit Gupta9y ago
1. SELECT Id, name, class
2. (IIF(class IS NULL , 0, 1) ) as exist
3. FROM test_Table