From an Employee table, how will you display the record
which has a maximum salary?
Answer Posted / sandeep
Select * from employee where rownum=1 order by sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When is the explicit cursor used ?
How can you load multi line records? : aql loader
how can you create an empty table from an existing table? : Sql dba
How many clustered indexes can you have?
what are the types of join and explain each? : Sql dba
what are the different index configurations a table can have? : Sql dba
What is cursor in pl sql with examples?
What do you mean by “trigger” in sql?
What are the types of dbms?
Can I call a procedure inside a function?
what is sql profiler? : Sql dba
What are the different type of joins in sql?
What is a natural join?
What is linq to sql?
What are the syntax and use of the coalesce function?