find out the second highest salary?
Answer Posted / chaitanya pathak
select max(salary) from employee
whrere salary<(selsect max(salary) from employee)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to define an oracle cursor variable?
What is hot backup and logical backup?
Differentiate between post-database commit and post-form commit?
Why does oracle 9i treat an empty string as null?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What are the attributes that are found in a cursor?
What is the quickest way to fetch the data from a table?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How would you change old and new values in an insert, delete and update triggers?
What is the minimum client footprint required to connect c# to an oracle database?
Can group functions be used in the order by clause in oracle?
Why do we use coalesce function in oracle?
How to drop a stored procedure in oracle?
How do I recompile a procedure in oracle?
What are oracle functions?