Dofactory.com
Dofactory.com
 Back to list
Views:   1.5K
Replies:  0
Archived

How Does (GROUP BY)'S Compilation Work ??

Hi,
I'm trying to know how the procedure done when using (group by) and how the result will be ordered without idintical data note even with these data the result still ambiguous , for example :
if we have a table has 2 columns (empno,ename)

empno    1    2    3    . ...........  26     
ename    a    b    c    . ............ z

then execute --------------------->

select ename , empno
from test
group by ename , empno

the result has to be to retrieve the table without changes but what happened illogical , so please help me to know the logic of (group by) .
Omer Al Saleh, May 06, 2018
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.