Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...
Answer Posted / amitkumar
Select TOP 1 salary from (select Distinct TOP 2 salary from
employee orderby salary desc)
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
how to handle exceptions in post production
What is instant client oracle?
What is an oracle database?
How to delete a user account in oracle?
How to drop an existing table in oracle?
How to connect ms access to oracle servers?
Explain the use of analyse option in exp command.
Explain what are the characteristics of data files?
What is a connect identifier?
Explain user account with reference to oracle.
How to define a variable to match a table column data type?
What is the oracle implicit cursor?
Can a parameter be passed to a cursor?
Why do we need integrity constraints in a database?