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
What is sql character function?
Enlist the characteristics of pl/sql?
How would you pass hints to the sql processor?
Why do we use sql constraints?
What is cursor status?
What is the default isolation level in sql server? : Transact sql
What is the difference between unique and primary key constraints?
How to rename a column in the output of sql query?
What is the location of pre_defined_functions.
what are the types of subquery? : Sql dba
Why triggers are used?
What is using in sql?
Are null values same as that of zero or a blank space?
Explain how can you save or place your msg in a table?
What is the maximum number of columns in sql table?