How to Select second Maximum salary in a Table ?
Answer Posted / ranjith
select salary from table order by salaray desc limit 1,1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to initialize variables with default values?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to assign values to variables?
What is query image?
How to view the tablespaces in the current database?
What are the logical operations?
What is the difference between 10g OEM and 11g OEM?
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 private procedure oracle?
how can we store any pdf file in oracle
Which is better Oracle or MS SQL? Why?
how to clone 9i Database on to 10g Database.
How to use values from other tables in update statements using oracle?
Design database draw er diagram for a certain scenario ?
What do you mean by a database transaction & what all tcl statements are available in oracle?