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

What is application trigger?

1001


How to revise and re-run the last sql command?

1163


How many joins can you have in sql?

937


how to drop an existing view in mysql? : Sql dba

1061


How can we debug in PL/SQL?

1136


What is clause?

1151


Can procedure in package be overloaded?

1085


What does closing a cursor do?

1322


How much ram can sql express use?

986


What is an exception in pl/sql?

1089


describe mysql connection using mysql binary. : Sql dba

1068


How would you pass hints to the sql processor?

982


What is sql and how does it work?

1175


What are the sql versions?

951


What is difference between primary and secondary key?

1027