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...

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


Please Help Members By Posting Answers For Below Questions

What is sql character function?

1149


Enlist the characteristics of pl/sql?

1844


How would you pass hints to the sql processor?

1040


Why do we use sql constraints?

1213


What is cursor status?

1236


What is the default isolation level in sql server? : Transact sql

1081


What is the difference between unique and primary key constraints?

1121


How to rename a column in the output of sql query?

1124


What is the location of pre_defined_functions.

1208


what are the types of subquery? : Sql dba

1158


Why triggers are used?

1037


What is using in sql?

1140


Are null values same as that of zero or a blank space?

1065


Explain how can you save or place your msg in a table?

1075


What is the maximum number of columns in sql table?

1228