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
Can you inner join the same table?
What is sap sql anywhere?
Which command is used to delete a package?
Is time a data type in sql?
What are stored procedures in mysql?
What is program debugging?
Is left join and outer join same?
How will you distinguish a global variable with a local variable in pl/sql?
What is a data definition language?
What is pl sql commands?
What is cross join example?
What is the most common sql injection tool?
What is crud sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
How to run sql statements through the web interface?