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 mutating sql table?

1118

Which are the different character-manipulation functions in sql?

1072

How do I turn a list into a table?

964

What is an exception in pl/sql?

1095

Is ms sql is free?

1026

What is the use of sqlerrd 3?

945

What is sqlite format?

1205

Why we use cross join?

959

How to sort the rows in sql.

1080

What are all the common sql functions?

1036

What are the three pl sql block types?

1013

What is the sql case statement?

1012

What are the uses of merge?

1169

Why do we use set serveroutput on?

973

What is structural independence and why is it important?

1032