I have a table like below :
create table id_test (
id number , name varchar2(20)
And records as below:
where I want to select only id's which have only name as 'sr'.
But as I have 100's of names so cannot put a not in condition to check other names.
The expected result would be like :