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
- 16801 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
Which tcl commands are available on the sql server?
What are date and time data types in ms sql server?
Explain the difference between primary keys and foreign keys?
Explain what is “asynchronous” communication in sql server service broker?
What is use of except clause? How does it differ from not in clause?
Is the order of columns in the set clause important in ms sql server?
Explain stored procedure?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is a trigger what are the advantages of trigger?
Do you know what is similarity and difference between truncate and delete in sql?
What is dbcc updateusage?
Explain what are commit and rollback in sql?
Explain about service Broker functions?
Tell me what is sql profiler?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
