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
How to Declare Fixed Length String Value In PL SQL
How do I count rows in sql?
what is table? : Sql dba
Is sql between inclusive?
Define sql delete statement.
what are the different type of sql's statements ? : Sql dba
Explain architecture of sql server notification services?
Why do we need view in sql?
How to run sql*plus commands in sql developer?
Can we commit in trigger?
How to create an array in pl/sql?
What is the largest value that can be stored in a byte data field?
What is pl sql architecture?
What is mutating table error?
How do I create a memory optimized filegroup?
