Really REALLY simple question (I think)

[beebee31]

I'm sure I used to know this but can't find it anywhere in my dusty mind.

How do you stop repeating data in a sql*Plus report?

e.g.

Select d.dname, e.emp_name
from emp e, dept d
where d.dept_id = e.dept_id

DNAME EMP_NAME
Boston Larry

Bill
Mark

D.C. Condoleeza

Dubya

Must be possible mustn't it? I thought it was SKIP or something to tell sqlplus to not repeat but I can't figure it out.

[beebee31]

Aww cr@p it was simple.... just in case anyone else is having amnesia...

It's the Break command in sql*plus :)

[nandini]

use keyword 'distinct'

[Mahesh_Bote]

don't need to user DISTINCT like keyword. there mustn't proper joing apllied in qry. thats why data redundancy appeared. plesae check the primary keys of both the tables and apply criteria, else use Group By

i.e.

Select A.Tab1, B.Tab1, C.Tab1, A.Tab2, B,Tab2, C.Tab2, D.Tab2
Where A.Tab1 = A.Tab2 And B.Tab1 = B.Tab2
Group By A.Tab1, B.Tab1, C.Tab1, A.Tab2, B,Tab2, C.Tab2, D.Tab2

in the above example, A, B are considered as PK.

Mahesh

[masdi2t]

e.g.

Select d.dname, e.emp_name
from emp e, dept d
where d.dept_id = e.dept_id

DNAME EMP_NAME
Boston Larry

Bill
Mark

D.C. Condoleeza

Dubya

Must be possible mustn't it? I thought it was SKIP or something to tell sqlplus to not repeat but I can't figure it out.

Yes, i think it's a Break command.
try this command before your SELECT statement

SQL> break on dname duplicates

thus command tell SQL*Plus to print duplicate value(s), for more information, feel free to type help break on SQL*Plus command window