how to get enames with comma seperated values by deptwise
on emp table?
Answer Posted / g
SELECT DEPT.DEPT_ID,LIST_AGG(E.EMP_NAME) FROM EMP E,DEPT D WHERE E.DEPT_ID=DEPT.DEPT_ID GROUP BY DEPT.DEPT_ID;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many triggers are allowed in mysql table? : Sql dba
What is plpgsql language?
What is the basic form of sql query?
What is cascade in sql?
What is the requirement of self-join?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Explain the savepoint statement.
What is the use of sqldataadapter?
What are secondary keys?
What are the types of dbms?
What are the different parts of a package?
Is primary key a clustered index?
Can we use rowid as primary key?
What is difference between hql and sql?
how to enter numeric values as hex numbers? : Sql dba