Interested to Buy Any Domain ? << Click Here >> for more details...
How to read 2nd highest sal from EMP table?
- 5 Answers
- 6156 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / arnab bhui
Using Oracle........
create table emp
( id number(10),
sal numeric(10,5)
);
SQL> select max(sal) from (( select sal from emp ) minus ( select sal from emp where sal >= all ( select sal from emp )));
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Is it safe to delete log files?
how to invoke a trigger on demand? : Sql server database administration
Which tools are available to manage SQL Azure databases and servers?
What is a deadlock and what is a live lock?
How to find index size for each index on table?
What is the concept of optimization?
Comment,Datatypes are unlimited
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
List the types of recovery model available in sql server?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How much memory that we are using in Logshipping Concept?
How to create a dynamic cursor with the dynamic option?
What is a trigger in sql server?
How do you open a cluster administrator?
