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
How many tables can a sql database have?
What is the difference between a subquery and a join?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is the difference among union, minus and intersect?
Is pl sql useful?
Explain ttitle and btitle.
how to present a past time in hours, minutes and seconds? : Sql dba
What are sql ddl commands?
What is pragma in pl sql?
What is query syntax?
What is an example of translating a date into julian format?
What is the max nvarchar size?
What is package in pl sql?
Why do you partition data?
how to write date and time literals? : Sql dba