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

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

Question Posted / rasmita basantia

Answer Posted / rasmita basantia

Is This Answer Correct ?

4 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is sql*plus?

1077

How many sql are there?

996

What is the primary use of normalization?

1002

List the ways to get the count of records in a table?

900

Explain the purpose of %type and %rowtype data types?

928

Explain the types of joins in sql?

1034

what are ddl statements in mysql? : Sql dba

1199

Is sql injection illegal?

1018

What is information schema in sql?

1070

What does varchar include?

947

what are the types of join and explain each? : Sql dba

1037

what are the drivers in mysql? : Sql dba

1020

What is dialect in sql?

946

What are its different types of dbms?

1004

What are the types of index in sql?

1069