how to get enames with comma seperated values by deptwise
on emp table?
- 8 Answers
- 9600 Views
- I also Faced
- E-Mail Answers
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
What is the difference between sql and mysql?
What is rownum in sql?
how to escape special characters in sql statements? : Sql dba
What is data types in sql?
What is minus?
What is the purpose of primary key?
How do I view a view in sql?
Do stored procedures prevent sql injection?
Explain the uses of control file.
What is before and after trigger?
What are the different dcl commands in sql?
How do you write an inner join query?
Is left join and outer join same?
How does a covering index work?
Is left join faster than join?
