Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.

Answer Posted / nancy

Select ename from table where dept_no in ('10','20') group
by dpt_no

Is This Answer Correct ?    4 Yes 27 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are null values? : Sql dba

959


Show the two pl/sql cursor exceptions.

1201


What is indexing in sql and its types?

1083


How do I view a procedure in sql?

978


What is the benefit of foreign key?

1022


how can I make a script that can be bi-language (supports english, german)? : Sql dba

1018


What is ttitle and btitle?

1068


What is materialized view in sql?

926


How delete all data from all tables in sql?

953


Which certification is best for sql?

993


Is sql better than access?

1021


Can you have more than one trigger on a table?

1003


Sql technical questions

1287


what is normalization? : Sql dba

1089


Which type of cursor is used to execute the dml statement?

961