Solve this

[SD007]

How can I select all columns of employees table where job_id column has unique
values,I want to exclude those rows of job_id column which have same value
for more than once.

[Dave44]

How can I select all columns of employees table where job_id column has unique
values,I want to exclude those rows of job_id column which have same value
for more than once.

depending on the size of the table i would probably want an index on job_id to have this perform well

SELECT *
FROM EMPLOYEES a,
(SELECT JOB_ID
FROM EMPLOYEES
HAVING COUNT(job_id) <= 1
GROUP BY job_id) b
WHERE a.job_id = b.job_id

hope this is what you are after...

[jigs]

you can use distinct with the job_id

say

select distinct job_id,x,y,z ...

[vijaydiwakar]

How can I select all columns of employees table where job_id column has unique
values,I want to exclude those rows of job_id column which have same value
for more than once.

select * from emp where job_id in (select distinct job_id from emp);