Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 89845 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / naveen
selec * from emp e1 (n-1)=(select count(distinct(sal) from
emp e2 where e1.sal<=e2.sal))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is redo log?
How to count groups returned with the group by clause in oracle?
Can we create database in oracle using command line ?
Why should I use oracle database?
What happens if recursive calls get out of control?
How many types of table in Oracle?
What is the sid in oracle?
How to get a list of all background sessions in the database?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Explain what does a control file contain?
What is a tns file?
What is rowid and rownum in oracle?
Explain integrity constraint?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to create a testing table in oracle?
