Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sathy
group by clause is used to group the column values using
corresponding column values
group by cannot use where condition, instead of where it can
use having which has same function as where
order by is used to order the records in order ie.,
ascending or descending.
order by can use where, but not having having is only for
group by.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is precompiler in db2?
What is load replace in db2?
What is db2 bind?
Explain package in db2 and its advantages?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How will you return the number of records in table?
List down the types of triggers in the db2 database?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Is db2 a programming language?
Mention the definition of cobol in varchar field.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the use of predicate?
What is the use of db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
