Answered Questions

  • how many columns can be in the group by clause

    Star Read Best Answer

    Editorial / Best Answer

    Srinivas4u  

    • Member Since Jul-2008 | Jul 16th, 2008


    I am sure that a group by clause can have all columns which are there in that table,not sure if you are looking for anotehr answer

    akshya dash

    • Jul 25th, 2011

    there can be n no of columns in a group by clause other than group functions for ex select ename, deptno max(sal) from emp group by ename,deptno; here max(sal) is a group function and ename and ...

    sasanka

    • Jul 21st, 2011

    In GroupBy clause contains the no of columns in the select Statement to retrieve the data.