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
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is package in pl sql?
What is the use of double ampersand (&&) in sql queries? Give an example
Is grant a ddl statement?
What does the argument [or replace] do?
what is the use of friend function? : Sql dba
What is left join in sql?
how to convert character strings to dates? : Sql dba
What do you understand by pl/sql records?
How to use sql statements in pl/sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is cursor in pl sql?
What is the purpose of the primary key?
explain primary keys and auto increment fields in mysql : sql dba
how to decrement dates by 1 in mysql? : Sql dba