find out the third highest salary?
Answer Posted / lakshmi
select sal from emp
where sal = (max(sal) from emp
where sal < (max(sal) from emp
where sal < (max(sal) from emp)));
Is This Answer Correct ? | 94 Yes | 135 No |
Post New Answer View All Answers
What is a snapshot log?
How to drop an index?
how to handle exceptions in post production
How to add another datafile to a tablespace?
what is normalisation?what are its uses?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to drop an existing table in oracle?
What is a system tablespace and when it is created?
What is snapshot is too old? Give and example for better understand.
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to get execution path reports on query statements?
What is a table index?
What is the relation of a user account and a schema?
Explain the difference between replace() and translate() functions in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..