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?

1109

What is a null value?

1143

How to look at the current sql*plus system settings?

1149

Why sql query is slow?

998

how to create a new table in mysql? : Sql dba

986

What is a sql schema used for?

1102

How to avoid using cursors?

1120

What is date functions?

1028

What is a crud api?

954

What are the two virtual tables available at the time of database trigger execution?

1222

does sql support programming? : Sql dba

1047

What is a primary key called that is made up of more than one field?

1351

What is a clob in sql?

1021

What is substitution variable?

1052

which types of join is used in sql widely? : Sql dba

982