How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / mk
select Name from emp where sal=(select distinct(Max(sal))
from emp
| Is This Answer Correct ? | 4 Yes | 14 No |
Post New Answer View All Answers
How to delete a column in an existing table?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is a package ? What are the advantages of package ?
What is the quickest way to export a table to a flat file?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Respected sir, Please send me technical questions related to oracle apps..
What are a collation and state the different types of collation sensitivity?
How can I introduce multiple conditions in like operator?
In which language oracle has been developed?
What is an oracle cursor variable?
Explain an integrity constrains?
How to call a sub procedure?
How to drop a stored function?
How to select an oracle system id (sid)?
What is an oracle and why it is used?