SELECT COUNT(Sal), COUNT(Comm) FROM Emp;

How can u find column name from a table which have max value
in a row.( not max value)

Question Posted / ajit

Answer Posted / ajit

SELECT COUNT(Sal), COUNT(Comm)
FROM Emp;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

define sql update statement ? : Sql dba

1109

What does the base_object_type column shows in the user.triggers data dictionary view?

1035

What is a native sql query?

1055

What is the use of nvl function?

1179

What is schema in sql?

936

What are the benefits of pl/sql packages?

1101

Enlist some predefined exceptions?

1051

What is the difference between instead of trigger and after trigger?

994

What is the difference between the implicit and explicit cursors?

1035

What is difference between rank () row_number () and dense_rank () in sql?

1095

What is sql performance tuning?

911

How does join work in sql?

1003

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

962

What is a relationship and what are they?

1137

Can a view be mutating? If yes, then how?

1011