Answer Posted / akki julak
FOR EXAMPLE WE HAD TAKE EMP TABLE AND ENAME,EMPNO AS COLUMNS
SELECT EMPNO,ENAME
FROM EMP
WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM EMP
GROUP BY EMPNO,ENAME);
by
AKKI JULAKANTI
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How do we accept inputs from user during runtime?
What is sql performance tuning?
What is native sql query?
What are the advantages of sql? Explain
Is coalesce faster than isnull?
How many indexes can be created on a table in sql?
Does truncate require commit?
What does count (*) do in sql?
what is a constraint? : Sql dba
How do I quit sql?
how can we know the number of days between two given dates using mysql? : Sql dba
Is drop table faster than truncate?
Explain what is sql*plus?
What is multiple columns?
Explain the order of sql statement execution?