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 debug stored procedure?
what is msql? : Sql dba
how to create a test table in your mysql server? : Sql dba
What are actual parameters and formal parameters?
what is acid property in database? : Sql dba
Why do we need a foreign key?
What is an exception in pl/sql?
What is pragma in pl sql?
What are the different types of dbms?
Is there any restriction on the use of union in embedded sql?
What are different types of triggers?
Can we connect to postgresql using sql developer?
what is the difference between cluster and non cluster index? : Sql dba
Is a secondary key the same as a foreign key?
Are null values same as that of zero or a blank space?
