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


Please Help Members By Posting Answers For Below Questions

there are N number of matchboxes numbered 1...N.each matchbox contain various number of stick.Two player can alternatevely pick some amount of stick from the higest stick containing box . The player is condidered win if there is no stick after his move.Find the final move so that the move player win. Note:In case the number of stick is equal ,pick the stick from the higest numbered box. eg: 3 box contain stick as:1,1,1. if u take 1 stick from 3rd numbred box you will any how win the match.

2430


why we use abstract in awt?

1562


Hi all... I had completed MSC(Computer) and had join the construction company based on sap.they want me to work on abap.but software company is totally different from construction company and they want me 2 grasp it as fast i can.i am finding it difficult.what should i do??????

1409


Q2. A memory location has physical address D5687h. Compute: a. The offset address if the segment number is D445h. b. The segment number if the offset address is B577h.

1633


How can we develop a multi-tier application in Java?

1472






3 members in a pf.how we read 3 members without using ovrdbf.using rg pgms....

1674


In mainframe SDSF, Can we copy the list of jobs currently executing in SDSF in to a seperate DATASET...?

1850


Please describe an example where you used object orientation in one of your programs.

1494


Why did you ever become involved in QA/testing?

1612


Write a pascal program to calculate the sum of the first 100 even number and odd number

3969


why not instantiating servet using new operator?

1498


in cobol,wat is the difference in using 'set index in occurs clause' ....and 'occurs depending-on clause'

1776


what is the difference between SCAN AND CHECK,LOKUP AND XFOOT? where we can use thease opcodes? Can any body tell me real time senariao with example?

2097


without selecting individually each field in Action Class from jsp,what is the best process to select as many as field at a time automatically from jsp page by using value object class.

1438


Which design patterns have you used?

1556