How to get distinct values in 2 columns in SQL server table

Question

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.

Answer 1

Hi,

One reason might be the DLL is not updated. 

Answer 2

Thank you so much Prasham Sabadra