Which Department has MOST NUMBER of employees?
Answer Posted / senthil
select column_name,count(*)from table_name group by
column_name having count(*)=(select max(count(*)) from
table_name group by column_name);
PLZ Contact Any Queries (raja.prem86@gmail.com)
Is This Answer Correct ? | 20 Yes | 27 No |
Post New Answer View All Answers
What happens to the current transaction if a ddl statement is executed?
How to test null values?
How to check the server version in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are nested tables?
What are triggers in oracle?
What is a nvl function?
What is set verify off in oracle?
What is PL/SQL ?
How to save query output to a local file?
What is oracle used for?
What are the logical operations?
How to rename an index in oracle?
How to convert a string to a date in oracle database?
What is a tns service name?