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...

how to get enames with comma seperated values by deptwise
on emp table?

Answer Posted / rasmita basantia

select ename ||' , '||deptno from emp order by deptno

Is This Answer Correct ?    4 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many tables can a sql database have?

959


What is the difference between a subquery and a join?

1074


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1199


What is the difference among union, minus and intersect?

982


Is pl sql useful?

967


Explain ttitle and btitle.

1105


how to present a past time in hours, minutes and seconds? : Sql dba

991


What are sql ddl commands?

1074


What is pragma in pl sql?

1087


What is query syntax?

954


What is an example of translating a date into julian format?

1100


What is the max nvarchar size?

944


What is package in pl sql?

1000


Why do you partition data?

1009


how to write date and time literals? : Sql dba

946