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
- 16565 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / ram
select region from tab2 where empid in(select empid from
tab1 where tshirtsize=3)
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
What is the contrast between sql and mysql?
Which table keeps information about stored procedures?
What is 5nf in normalization form?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is the difference between drop table and truncate table?
How to set the current database in ms sql server?
What is db stored procedure?
What is precedence constraint?
How to disable triggers using "disable trigger"?
What are relationships and mention different types of relationships in the dbms
What is sql stored procedure?
Is it possible for a stored procedure to call itself or recursive stored procedure?
List out the different types of locks available in sql server?
Is null vs coalesce?
What is temporary table in sql server? Why we use temp table?
