Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
How to get distinct values in 2 columns in SQL server table
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Kumar AU
10y
672
1
Reply
Table 1
APPID | CERTID |
CERTNAME
--------------------------------
11111 |
1
|
ABCD
22222 |
2
|
EFGH
33333 |
3
|
IJKL
11111 |
4
|
XYZ
44444 |
5
|
JHJ
22222 |
6
|
KJHK
11111 |
7
|
TUHJ
Note:- here cert is is PK and its not repatable where as App Id is repetable columns values
In this table How do I get distinct App Id and corresponding certId ,
This is my query , here still I am getting duplicate AppId's
Select distinct(APPID),CERTID from Table1
Please Please Can any one help me.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Executing stored procedure in select query
SQL query