Interested to Buy Any Domain ? << Click Here >> for more details...
can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
- 15 Answers
- 16423 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / sitaram karancheti
In Oracle:
SELECT COUNT(table1.emp_id), region
FROM table1, table2
WHERE tshirt_size = 3 AND table1.emp_id = Table2.emp_id
AND rownum < 2
GROUP BY region
ORDER BY COUNT(table1.emp_id) DESC
In MySql:
SELECT COUNT(table1.emp_id), region
FROM table1, table2
WHERE tshirt_size = 3 AND table1.emp_id = Table2.emp_id
GROUP BY region
ORDER BY COUNT(table1.emp_id) DESC LIMIT 1
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is lock escalation? : sql server database administration
What are different types of subquery?
What is scrollable cursor?
What is 'Join' and explain its various types.
What are recommended options to be used while using db mirroring? : sql server database administration
What is a data source file?
What are the reporting services components?
What is simple indexing method?
How do you create type- insensitive operator?
What is a performance monitor?
Do you know the cursor types?
How to convert a table data in XML format in sql server?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How to run sql server 2005 books online on your local system?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
