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


From an Employee table, how will you display the record
which has a maximum salary?

Answers were Sorted based on User's Feedback



From an Employee table, how will you display the record which has a maximum salary?..

Answer / amedela chandra sekhar

sql> select * from emp where sal=(select max(sal) from emp);







chandumba2005@gmail.com

Is This Answer Correct ?    2 Yes 0 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / mayank kumar

<-- it will display max salary only-->
Select max(distinct salary)
from employee;



<-- it will display all information of employee having max salary -->

select * from employees
where salary=(select max(distinct salary) from employees);

Is This Answer Correct ?    2 Yes 0 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / anil

select * from test.emp where salary=(select max(salary) from test.emp);

Is This Answer Correct ?    1 Yes 0 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / amit kumar agarwalla

select * from employees
where salary=(select max(salary) from emplpoyees);

Is This Answer Correct ?    1 Yes 0 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / mrityunjay singh

select *from employees where rownum<2 order by salary desc;
or
select * from employee where sal=(select max(sal) from
employee);

Is This Answer Correct ?    1 Yes 0 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / mohan

select * from emp where sal in(select max(sal) from emp);

or

select * from emp where sal=(select max(sal) from emp);

Is This Answer Correct ?    0 Yes 0 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / pree

Select name,salary from Employee where salary in(select max
(salary)
from Employee );

Is This Answer Correct ?    0 Yes 0 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / apsar

select * from (select e.* from emp order by e.sal desc)

Is This Answer Correct ?    0 Yes 0 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / dinesh kumar

select * from employee where salary =( select max(salary) from
employee);

Is This Answer Correct ?    0 Yes 0 No

From an Employee table, how will you display the record which has a maximum salary?..

Answer / sandeep

Select * from employee where rownum=1 order by sal desc

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What do you mean by stored procedures?

0 Answers  


I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,


How does one load ebcdic data? : aql loader

0 Answers  


How to connect a sql*plus session to an oracle server?

0 Answers  


What is the purpose of a sql?

0 Answers  


Why cross join is used?

0 Answers  


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

0 Answers  


What is the difference between the conventional and direct path loader? : aql loader

0 Answers  


Write an sql query to select all records from the table?

0 Answers  


Show the cursor attributes of pl/sql.

0 Answers  


Is sql considered coding?

0 Answers  


How can I speed up sql query?

0 Answers  


Categories