Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Check duplicate names in SQL server table
Nanda Kishore Chandrapati
Aug 28 2017 10:55 AM
172
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Convert Dataset to json string in sql server
Sql Database is not accessible from another User Account