wt is the diff b/w greast and max ,least and min?
wt is the diff b/w case and decod?
Answer Posted / shivaindu
greatest/Least: we can pass any no. of exp
Max/Min: we can pass one exp that may a column
Case: is a statement function, cannot process null
Decode: is a function, can process null, we can use in
update statement.
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
Is sql a scripting language?
What is a constraint?
How do I find duplicates in the same column?
What is denormalization in a database?
What is orm in sql?
How do I make sql search faster?
Is postgresql a nosql database?
what are tables and fields? : Sql dba
what does myisamchk do? : Sql dba
What are the built in functions of sql?
What packages are available to pl/sql developers?
What are the different sql commands?
Can a foreign key have a different name?
what is a constraint? : Sql dba
What are inner outer left and right joins in sql?