Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

select sal from emp group by sal

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


Please Help Members By Posting Answers For Below Questions

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1066


What is package in pl sql?

1031


What is the use of double ampersand (&&) in sql queries? Give an example

1146


Is grant a ddl statement?

905


What does the argument [or replace] do?

1095


what is the use of friend function? : Sql dba

1029


What is left join in sql?

1060


how to convert character strings to dates? : Sql dba

1071


What do you understand by pl/sql records?

1025


How to use sql statements in pl/sql?

1133


what is the difference between inner and outer join? Explain with example. : Sql dba

1036


What is cursor in pl sql?

1122


What is the purpose of the primary key?

1068


explain primary keys and auto increment fields in mysql : sql dba

983


how to decrement dates by 1 in mysql? : Sql dba

1025