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
- 17388 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 the cartesian product of table?
Explain the concept of recursive stored procedure.
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is the difference between primary key and unique constraints?
How to trouble shoot if unable to connect SQL Server
What is key set driven?
How to create a new login name in ms sql server?
What is a data source or ds? : sql server analysis services, ssas
What are the different types of collation sensitivity in sql server?
How to find out the list schema name and table name for the database?
how can a database be repaired? : Sql server administration
Tell me what is de-normalization and what are some of the examples of it?
What is plan freezing?
How do you send email on SQL Server?
what method you can use to reduce the overhead of Reporting Services data sources?
