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 application trigger?
How to revise and re-run the last sql command?
How many joins can you have in sql?
how to drop an existing view in mysql? : Sql dba
How can we debug in PL/SQL?
What is clause?
Can procedure in package be overloaded?
What does closing a cursor do?
How much ram can sql express use?
What is an exception in pl/sql?
describe mysql connection using mysql binary. : Sql dba
How would you pass hints to the sql processor?
What is sql and how does it work?
What are the sql versions?
What is difference between primary and secondary key?