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 cost in sql execution plan?

1045


What is not null in sql?

1109


explain about mysql and its features. : Sql dba

1053


What is rowtype?

1080


What is oracle sql developer?

1118


Is mariadb a nosql database?

1099


Why is nosql good?

1083


what is view? : Sql dba

1029


What is a left inner join?

1069


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1265


what is auto increment? : Sql dba

1051


What are the types of views in sql?

1141


Can sql function call stored procedure?

1074


What are the types of join and explain each?

1101


does sql support programming? : Sql dba

1088