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

Aug 28 2014 6:42 AM

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.

Answers (2)