Submitted Questions

  • Jul 16 2008
    06:59 AM
    4265
    0

    Students SQL Query
    • radha11

    these are the columns in the exam_report tableEXAM_CODE,STUDENT_ID,USER_ID,FIRST_NAME,STUDY_CENTER,COURSE,PAPER,APPEARENCEnow i want to know how many student have passed at the end of the yr for each paper? and if they r failed i need to know there mark of the last appearance for each paper(ie)he might have appeared 5 times but still he may have failed and i want the mark of the 5 appearance

  • Jul 16 2008
    05:58 AM
    9528
    40

    how many columns can be in the group by clause
    • radha11

    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.