1.group by clause explain along with an example
Answer Posted / guest
The GROUP BY clause will gather all of the rows together
that contain data in the specified column(s) and will allow
aggregate functions to be performed on the one or more
columns.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
how we can know the funcions available in a class recording java?
what is the BAM? where we can use it in BizTalk server?
Delta 5 weight scale not connect with oracle application what i can do?
What are two of your strengths that you will bring to our QA/testing team?
what is class module in vb6? what it's use? with example..
if 3 duplicate records, by keeping one original and one duplicate record, and how to delete remaining 2 duplicates in sql server 2008
Given an array of size n. It contains numbers in the range 1 to n. Each number is present at least once except for 1 number. Find the missing number
Is buffer size and file block size is similar? If similar,at which case it will be same size?
what is the work of 1tier,2tier,&ntier? Plz Explain it!
In OB52 , How to define two open posting period, Like only 5 and 8 posting should be open.. should not open 6 and 7..period..
how do you generate source code for the automatic generation for receipt number
can we retrieve only integer/String type columns from a table,if yes how?
EXPLAIN UNARY OPEARATORS
I m Abdullah Ansari compleated MCA from Jamia Hamdard,i have appeared the test of IBM on 2 august at oxford college of engineering Bangalore.waiting for hr round.. This is the first round for IBM.02/08/08 Paper consists of 4 sections 15 questions from matrices(time very less but no negative marking). 25 questions from series completion section (this section is very easy but negative marking) 15 questions from aptitude(little bit tough time limit 15 minute negative marking) 4th section is from computer science (c,c++,operating system,digital electronics ,basic question..) result came at 3 o'clock.i was selected... In interview they asked questions like 1 they asked about final yr project.. 2 what are dynamic and static memory location? 3 linked list and array difference between them. 4 what is function ? what is difference betwen function and inline function? 5 about structure 6 about binary tree, traversal, call by value. 7 storage class and many more basic questions..
Difference between HTML and DHTML?