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
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 are scalar functions in sql?
What is difference between after and before?
How to list all dsn entries on your local machine using odbc_data_source()?
What happens if the update subquery returns no rows in ms sql server?
Difference between LEN() and DATALENGTH() in sql server ?
What is the recovery model? List the types of recovery model available in sql server?
Can a trigger be created on a view?
What is primary key, unique key, and foreign key?
What are partitioned views and distributed partitioned views?
What are the differences between clustered and non-clustered index?
Where in ms sql server is ’100’ equal to ‘0’?
What is dimension table? : sql server analysis services, ssas
Why use identity in sql server?
what's the maximum size of a row? : Sql server database administration
What is normalization and denormalization in sql server?