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



wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?..

Answer / satya

simply greatest,least are rowlevel functions
max,min are the column level functions

Is This Answer Correct ?    10 Yes 2 No

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?..

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

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?..

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

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?..

Answer / prakasha

n0

Is This Answer Correct ?    2 Yes 15 No

Post New Answer

More SQL PLSQL Interview Questions

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?

2 Answers   HSBC,


Why sql query is slow?

0 Answers  


What plvcmt and plvrb does in pl/sql?

0 Answers  


What do you know by pl/sql cursors?

0 Answers  


What is gpt format?

0 Answers  






how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,


how to install mysql? : Sql dba

0 Answers  


What is difference between ms sql and mysql?

0 Answers  


What is the difference between join and natural join?

0 Answers  


Is join an inner join?

0 Answers  


What are different categories of sql commands?

0 Answers  


What are aggregate functions in sql?

0 Answers  


Categories