Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / prakasha

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

What is database white box testing and black box testing?

0 Answers  

what is the difference between nested subquery and correlated subquery?

0 Answers  

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

Explain the difference between triggers and constraints?

0 Answers  

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

What if we write return in procedure?

0 Answers  

How many types of indexes are there in sql?

0 Answers  

How to convert comma separated string to array in pl/sql?

0 Answers  

How do you use a while loop in pl sql?

0 Answers  

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

What is the life of an sql statement?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories