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...

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

Answer Posted / selvaraj v , anna university c

select ename, salary from emp where salary=(select max
(salary) from emp) order by emp_no;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what does the t-sql command ident_current does? : Transact sql

989


How to start the command-line sql*plus?

1061


Is sql injection illegal?

1031


What are different sql data types?

1055


What is query syntax?

980


What is sqlite format?

1207


What is the left table in sql?

974


Name the operator which is used in the query for pattern matching?

967


Can we call a function containing dml statements in a select query?

989


how to use 'mysql' to run sql statements? : Sql dba

1061


What is the purpose of using pl/sql?

1155


What is the difference between having and a where in sql?

1113


What does the sign mean in sql?

1000


What is meant by truncate in sql?

1074


Which is faster union or join?

981