select column_name,count(*)from table_name group by column

Which Department has MOST NUMBER of employees?

Question Posted / senthil

8 Answers
51419 Views
IBM, LeadSquared, Mastek, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is a database table in oracle?

1069

How a database is related to tablespaces?

1083

What is transport network substrate (tns) in oracle?

1091

How to import one table back from a dump file?

1085

How to assign values to variables?

1163

What is open database communication (odbc) in oracle?

1048

What are the attributes of cursor?

1104

Explain oracle 12c new features for developers?

1125

How to delete an existing row from a table in oracle?

1129

Can we store pictures in the database and if so, how it can be done?

1089

How does Oracle guarantee data integrity of data changes?

2456

What is data file?

1149

How to write a left outer join with the where clause in oracle?

1132

what is the difference between data migration and production migration.

2397

How to use in conditions in oracle?

1115