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 and also describe types of sql statements?
What are the disadvantages of not performing database normalization?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is the difference between unique and primary key constraints?
How many developers work on postgresql?
How to process query result in pl/sql?
What is function and procedure?
Why partition by is used in sql?
What is a call statement? Explain with an example.
What is union and union all keyword in sql and what are their differences?
Is sqlite thread safe?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
How can I make sql query run faster?
What are sql procedures?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?