How to Select second Maximum salary in a Table ?
Answer Posted / a.swarna devi
select max(sal)from table;
| Is This Answer Correct ? | 2 Yes | 13 No |
Post New Answer View All Answers
What are advantages of dateset in datastage?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Design database draw er diagram for a certain scenario ?
How to drop a stored function?
What happens if recursive calls get out of control?
What happens if the imported table already exists?
What are the types of trigger in oracle?
What happens to the data files if a tablespace is dropped?
How to insert a record into a table?
What are the different editions of oracle?
How to store pictures on to the database?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to sort output in descending order in oracle?
What the is the diff between local index and global index. give some example.
What is oracle used for?