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

Which join is like inner join?

1089


Explain autonomous transaction.

1220


What is difference between my sql and sql?

1139


What is the difference between microsoft access and sql server?

1107


How delete a row in sql?

1042


explain the difference between bool, tinyint and bit. : Sql dba

1063


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1265


What is an inner join sql?

1099


what are the differences between require and include, include_once and require_once? : Sql dba

1069


What does fetching a cursor do?

1133


Why do we create views in sql?

1218


What does desc stand for?

1123


Why do we need unique key in a table?

1005


What is the use of %rowtype?

1086


How to know the last executed procedure?

1156