From an Employee table, how will you display the record
which has a maximum salary?
Answer Posted / sudeep mishra
select *
from employee
where salary = max sal
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is meant by <> in sql?
Can we insert data into materialized view?
What is the most important ddl statements in sql are?
What is rename command in sql?
How to test for null values?
What is cte?
How can I delete duplicate rows?
Why we use join in sql?
how can you see all indexes defined for a table? : Sql dba
Why do we use joins in sql?
What is dense_rank?
What are the properties of a transaction?
Can procedure in package be overloaded?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Is pl sql still used?