wt is the diff b/w greast and max ,least and min?
wt is the diff b/w case and decod?

Answer Posted / satya

simply greatest,least are rowlevel functions
max,min are the column level functions

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to pass parameters to triggers?

571


what is 'mysqld'? : Sql dba

540


What is the difference between a database and a relational database?

558


Can we have two clustered index on a table?

562


What is data profiling in sql?

511






tell me about various levels of constraint. : Sql dba

528


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1638


Mention what is the use of function "module procedure" in pl/sql?

561


How do you delete data from a table?

537


Does inner join remove duplicates?

518


Explain 3 basic parts of a trigger.

830


what is commit? : Sql dba

615


What is a column in a table?

548


Why truncate is used in sql?

527


What is sql comments?

648