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

Can we use ddl statements in stored procedure?

1095


How is a PL/SQL code compiled?

1171


what is the difference between myisam static and myisam dynamic? : Sql dba

1002


Is pl sql still used?

925


What is break?

1140


What are the parts of a basic sql query?

918


What are local and global Indexes and where they are useful.

1377


Explain the difference between triggers and constraints?

919


What are packages in pl sql and also explain its advantages?

959


What is difference between sql and mysql?

1064


Describe sql comments?

959


How many disk partitions should I have?

941


What is not equal in sql?

1006


What is the main reason behind using an index?

965


What is left join in sql?

1004