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

Do we need commit after truncate?

616


How to prepare for oracle pl sql certification?

572


How many unique keys can a table have?

561


How are functions and procedures called in PL/SQL?

593


When are we going to use truncate and delete?

555






What are the different set operators available in sql?

566


What is meaning of <> in sql?

588


What are the main features of cursor?

631


How to get each name only once from an employee table?

611


Does google use sql?

517


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

604


Does normalization improve performance?

555


What is file based approach?

492


What are tables and fields in the database?

555


Can we join 3 tables in sql?

499