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

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

What is the requirement of self-join?

0 Answers  

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

What is pessimistic concurrency control? : Transact sql

0 Answers  

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

Is a view faster than a stored procedure?

0 Answers  

What is difference between stored procedures and application procedures?

0 Answers  

Can we insert data in view?

0 Answers  

Can we use join in subquery?

0 Answers  

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

Does oracle roll back the transaction on an error?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories