We should not use DISTINCT in SQL query, it takes more up.

Select distict ename,enum

from emp

where ename=’krishna’

and enum=1000

The alternative way is:

Select ename,enum

from emp

where ename=’krishna’

and enum=1000

group by ename,enum