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 data manager?
What is the clustering index in the db2 database?
Explain the function of data manager.
What is dbrm library?
what is a corelated subquerry?
What's The Error Code For Unique Index Voilation?
What is check constraint in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is the function of logging in the db2 database?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Why do chiropractors use drop table?
List down the types of triggers in the db2 database?
What is an instance in db2?
What is dbrm in db2 database?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
