Interested to Buy Any Domain ? << Click Here >> for more details...
Which Department has MOST NUMBER of employees?
- 8 Answers
- 51052 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
Explain drop constraint oracle?
What are group functions in oracle?
What do you mean by a deadlock?
How to use "for" statements in oracle?
What is an oracle and why it is used?
Does oracle partitioning improve performance?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to select an oracle system id (sid)?
if you ctreate table identity
Write a syntax for update query in oracle?
How do I spool in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Difference between inner join vs where ?
Give the advantages and disadvantages of clusters.
What is blob data type in oracle?
