How can u find column name from a table which have max value
in a row.( not max value)

Answer Posted / ajit

SELECT COUNT(Sal), COUNT(Comm)
FROM Emp;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between delete, truncate and drop command?

547


Can we use join in subquery?

565


how are mysql timestamps seen to a user? : Sql dba

561


Why do we create views in sql?

549


What is the difference between the implicit and explicit cursors?

523






What is the use of triggers?

541


Why trigger is used in sql?

525


What is the difference among union, minus and intersect?

544


What is sql*loader?

570


What is sqlite used for?

528


Can a table contain multiple foreign key’s?

569


what is the difference between union and union all? : Sql dba

544


What is pl sql block in dbms?

524


Can we use loop in sql?

533


What are the uses of merge?

717