wt is the diff b/w greast and max ,least and min?
wt is the diff b/w case and decod?
Answers were Sorted based on User's Feedback
Answer / satya
simply greatest,least are rowlevel functions
max,min are the column level functions
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / 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 |
Answer / jyothi
greatest gives largest value from the list of values passed
where as max gives maximum value in that column.similarly
least and min too.
decode performs only equality conditions and it doesn't work
in plsql.process null.
case compares all the cases.null cannot processed. case
performs all the actions of decode and it works in pl/sql.
Is This Answer Correct ? | 4 Yes | 0 No |
I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
Why sql query is slow?
What plvcmt and plvrb does in pl/sql?
What do you know by pl/sql cursors?
What is gpt format?
how to retrieve the top 2 salaried persons from a database?
how to install mysql? : Sql dba
What is difference between ms sql and mysql?
What is the difference between join and natural join?
Is join an inner join?
What are different categories of sql commands?
What are aggregate functions in sql?