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 / padmavasireddy

Thnak you karthick and ram

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between function and stored procedure?

600


What according to you is the difference between mysql and sql server performance?

653


What are the steps to insert a table?

622


How to check if a table is being used in sql server?

598


What is inner join? Explain with an example?

772






What are distinctive joins find as a part of sql?

626


What do you mean by the term 'normalization'?

763


How to enforce security in sql server? : sql server security

712


What is SQL Server?

752


can a database be shrunk with users active? : Sql server administration

649


What number aggregate functions are accessible there in sql?

682


What gets stored inside msdb database?

844


Explain forward - only cursors?

600


What are the different methods available under sqlcommand class to access the data?

779


What is indexed view? How to create it?

675