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
Can we use ddl statements in stored procedure?
How is a PL/SQL code compiled?
what is the difference between myisam static and myisam dynamic? : Sql dba
Is pl sql still used?
What is break?
What are the parts of a basic sql query?
What are local and global Indexes and where they are useful.
Explain the difference between triggers and constraints?
What are packages in pl sql and also explain its advantages?
What is difference between sql and mysql?
Describe sql comments?
How many disk partitions should I have?
What is not equal in sql?
What is the main reason behind using an index?
What is left join in sql?