Search:

Maximum number of employees means,
say suppose in dept 10 ,
there were 5 no of emps joined in Jan,
there were 10 no of emps joined in FEb and
there were 2 no of emps joined in March.
So the O/P...

Could you pls gimme another example for this and
some more advantages of Decode command over "If-then-else" stmt.

Regards

Maximum number of employees means,
say suppose in dept 10 ,
there were 5 no of emps joined in Jan,
there were 10 no of emps joined in FEb and
there were 2 no of emps joined in March.
So the O/P...

Dear all,

please tell me, what is the advantage of "DECODE" command over the
" IF-THEN-ELSE" statement in PL/SQL .

We can use " IF-THEN-ELSE" , why we are using "Decode" command?
What is...

Hi all,

Can you give me the query for
Say suppose the table "EMP" contains 2006 th year record only:

So in 2006 "On which month , the maximum number of employees have been joined in each and...

Delete from <table_name> where rowid not in(select min(rowid) from
<table_name> group by <all_primary_key_columns>);