Interested to Buy Any Domain ? << Click Here >> for more details...
Write query to fetch second maximum salary from employee table.
- 4 Answers
- 7337 Views
- Bravura Solutions, HCL, I also Faced
- E-Mail Answers
Answer Posted / vijayalakshmi
select top 1 Coumn_Name from (select top 2 Coumn_Name from Table_name order by Coumn_Name desc) b order by Coumn_Name
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to set up autotrace for a user account?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is private procedure oracle?
Where is the export dump file located?
What are set operators?
What is ADDM Advisor in Oracle?
How to use select statement to count the number of rows in oracle?
Can we insert data in view 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.
How to delete all rows a table in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Explain what are the type of synonyms?
State the difference between a primary key and foreign key?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to enter a new row into a table interactively?
