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 view means?

1020

what are all types of user defined functions? : Sql dba

1082

Can there be more than one function with a similar name in a pl/sql block?

1035

What is pivot query?

1115

Is sql the best database?

1017

How do you delete duplicates in sql query using rowid?

984

what is sub-query? : Transact sql

1152

What is difference between hql and sql?

1158

What does varchar include?

988

Is there a 64 bit version of ssms?

997

What is oracle sql called?

970

What is union, minus and interact commands?

1361

What are the different ways to optimize a sql query?

984

explain advantages of myisam over innodb? : Sql dba

1107

Is sql between inclusive?

1190