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 does the acronym acid stand for in database management?

983

Enlist the advantages of sql.

937

Are stored procedures compiled?

870

What are the two characteristics of a primary key?

926

What is a temporal data type?

978

What are the parameter modes supported by pl/sql?

1019

Explain the select statement in sql?

1043

Show code of a cursor for loop.

1000

how to convert character strings to dates? : Sql dba

982

what is self join and what is the requirement of self join? : Sql dba

1075

Is it possible to create the following trigger: before or after update trigger for each row?

1236

What is a subquery in sql?

975

What is sequence in sql?

938

How can we make an if statement within a select statement?

957

Does oracle use sql?

877