Interested to Buy Any Domain ? << Click Here >> for more details...
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 do I partition in sql?
Explain what is sql?
What are the types of subqueries?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is primary key and foreign key with example?
How can the performance of a trigger be improved?
what are wild cards used in database for pattern matching ? : Sql dba
What port does sql server use?
Is the primary key an index?
What are local and global variables and their differences?
tell me about various levels of constraint. : Sql dba
What does cursor do in sql?
What is the difference between union and union all command?
What is primary key and unique key?
Can a select statement fire a trigger?
