How to Select second Maximum salary in a Table ?
Answer Posted / ranjith
select salary from table order by salaray desc limit 1,1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to retrieve the count of updated rows?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How many data types are supported?
what are the advantages of running a database in archive log mode?
Explain how are indexes update?
What happens to the current transaction if the session is killed?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to open a cursor variable?
How to connect to a remote server?
In oracle there is column command, how will you explain that?
What is oracle update statement with inner join ?
Is oracle the best database?
What is where clause in oracle?
How many types of database triggers exist?