Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 91316 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / anil
Guys try this to get 2nd highest salary
select max(salary) from employee where salary not in (select
max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we create database in oracle using command line ?
What is difference between truncate and delete?
What is SQL access advisor in Oracle?
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.
What is ADDM Advisor in Oracle?
What is instant client oracle?
What is Reduced List of Values?
What are the most common interview questions on ETL Testing for experience?
What is a oracle database?
What is the disadvantage of User defind function?
How are extents allocated to a segment?
How to define an oracle cursor variable?
How do I know if oracle is installed on windows?
What do you mean by merge in oracle and how can you merge two tables?
How to display row numbers with the records?
