Kramer

How can display an instance of a table and null if that instance is repeated in the same table asshown in the attachment pic DEPTNO, LOC, and DEPTNAME each row is shown once as long as the next row has the same entry. eg. there is three employees in departemen…

NOTE: By fault I've written 375 it supposed to be 365. TRUNC function takes a number and number of decimal digits. 0 means no need to show the decimals, in the other hand 365 is the number of days in the year. As a conclusin, you divide on the number of days i…

Thats right, but needs ptimization so that it can be in one query. That is : select ename, trunc((sysdate-hiredate)/375, 0)"Years At Work" from emp; Thanks.

I think he is right