i have a simple query
select distinct(ID),group,inquiry,entry from SCRTY_TBL_GROUP where institution='007';
I want this query to return me columns where ID is unique along with the rest of the other columns but this is returning all the rows. What is the problem? how can i solve this?