Interested to Buy Any Domain ? << Click Here >> for more details...
Which Department has MOST NUMBER of employees?
- 8 Answers
- 51409 Views
- IBM, LeadSquared, Mastek, I also Faced
- E-Mail Answers
Answer Posted / sts
Select Deptno,Count(*) from Emp Group By Deptno having Count(*)=(SELECT max (count(*)) FROM EMP GROUP BY DEPTNO);
| Is This Answer Correct ? | 24 Yes | 13 No |
Post New Answer View All Answers
How to convert raw data type into text in oracle? Explain
How to empty your oracle recycle bin?
How many categories of data types in oracle?
State any two functions of oracle?
Is java required for oracle client?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Why do we need integrity constraints in a database?
How do I know if oracle client is installed on windows?
How translate command is different from replace?
When do I need to use a semicolon vs a slash in oracle sql?
What is literal?
Give syntax for SQL and ORACLE joins.
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is a tns file?
What privilege is needed for a user to delete rows from tables in another schema?
