Answer Posted / arun karthick
select sal from emp group by sal; and select distinct sal
from emp ;
Both queries will give the same result - fetch the salary
in emp table without duplicates.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In what condition is it good to disable a trigger?
What do you mean by stored procedures? How do we use it?
What is the starting oracle error number? What is meant by forward declaration in functions?
Can sql developer connect to db2?
What is the use of primary key?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
what are the join types in tsql? : Transact sql
What are the differences between implicit and explicit cursors?
What is the difference between a procedure and a function?
Can a trigger call a stored procedure?
What kind of join is join?
What is embedded sql with example?
What is the left table in sql?
What is sap sql?
Does user triggers have entry for trigger with compilation errors?
