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 do you tell what your machine name is and what is its IP address?
Explain cascading triggers.
How to invoke the data pump export utility?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What are operators in oracle?
what are actual and formal parameters?
How to end the current transaction in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to change system global area (sga) in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to create a new table by selecting rows from another table?
What is a table index?
How to define an oracle cursor variable?
How to assign values to variables?