SELECT MAX(SAL)AS MAXIMUMSALARY FROM EMP

From an Employee table, how will you display the record
which has a maximum salary?

Question Posted / senthilkumar

Answer Posted / senthilkumar

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do you write a subquery?

1070

How do you create a db file?

1068

What is trigger explain it?

1078

What is input buffer in sql*plus?

1293

How do you modify a table in sql?

1165

Is left join inner or outer?

1057

What are actual parameters and formal parameters?

1176

Can we call stored procedure in function?

1002

Is sql the best database?

1027

Is inner join same as self join?

1168

What is sql trigger example?

1115

What are sql functions? Describe in brief different types of sql functions?

1180

Explain the rollback statement?

1072

How can a function retun more than one value in oracle with proper example?

1128

How to check if a column is nullable before setting to nullable?

1186