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 the use of desc in sql?
What are the different types of dbms?
How do you run a query?
What is benefit of creating memory optimized table?
What is an exception in pl/sql?
What is execute immediate?
How do I install sql?
Explain isolation levels. : Transact sql
What is the use of double ampersand (&&) in sql queries? Give an example
What is index example?
Can you inner join the same table?
Are left and right joins the same?
discuss about myisam index statistics collection. : Sql dba
Which nosql database is best?
How can we debug in PL/SQL?