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

What is the purpose of using pl/sql?

1125

What is a sql driver?

985

What is the difference between between and in condition operators?

985

What is a dirty read sql?

1109

Differentiate between pl/sql and sql?

1132

What is sql table?

950

Can we write ddl statements in functions?

1094

What are different types of sql commands?

1094

What is the difference between union and union all command?

1061

What is bulk collect in pl sql?

1075

What are triggers and its types?

1041

How does rowid help in running a query faster?

1402

define join and explain different type of joins? : Sql dba

934

Can we rename a column in the output of sql query?

977

What is a variable in sql?

981