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...
Type: Posts; User: prasathlogu; Keyword(s):
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>);