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
What is cost in sql execution plan?
What is not null in sql?
explain about mysql and its features. : Sql dba
What is rowtype?
What is oracle sql developer?
Is mariadb a nosql database?
Why is nosql good?
what is view? : Sql dba
What is a left inner join?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
what is auto increment? : Sql dba
What are the types of views in sql?
Can sql function call stored procedure?
What are the types of join and explain each?
does sql support programming? : Sql dba