How to fetch the row which has the max value for a column?

Question Posted / bhanu bhandula

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle General Interview Questions

can you call insert/update/delete in select statements. If yes how? If no what is the other way?

How to enter a new row into a table interactively?

Difference between varchar and varchar2 data types?

how to we delete a row using varray

Query to get max and second max in oracle in one query ?

Explain how you would restore a database using RMAN to Point in Time?

How to import one table back from a dump file?

What happens if the imported table already exists?

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

How do I escape a reserved word in oracle?

how will I find the first 5 highest salaried employees in each dept in oracle.

What is an index associated with a constraint?

For more Oracle General Interview Questions Click Here