Click here to Skip to main content
15,918,303 members

Comments by akshay_DBA (Top 3 by date)

akshay_DBA 17-Nov-17 0:33am View    
dnt knw. . thats why i need a solution
akshay_DBA 17-Nov-17 0:32am View    
javascript
akshay_DBA 1-Nov-17 2:42am View    
SQL> SELECT LEAVE_summary.EMP_ID, sum(sick_leave.N_O_D) AS N_O_D,sum(LEAVE_summary.tc)- sum(sick_leave.N_O_D) AS Remaining_Leaves
2 FROM LEAVE_summary INNER JOIN sick_leave ON(LEAVE_summary.EMP_ID=sick_leave.EMP_ID)
3 WHERE LEAVE_summary.emp_id=@empid
4 GROUP BY LEAVE_summary.emp_id;
WHERE LEAVE_summary.emp_id=@empid
*
it is giving a error missing exprssn