Click here to Skip to main content
15,906,816 members

Comments by DARSANA K (Top 4 by date)

DARSANA K 13-Mar-13 5:26am View    
empid scode amt date
-----------------------------------------------
1 e 1000 2013-03-12
1 a 100 2013-03-12
1 d 500 2013-03-12
1 e 1000 2013-03-12
1 e 500 2013-03-12
suppose this is the table

and o/p like
totalearnings|totaldeductions
---------------------------------
2500 | 500
DARSANA K 13-Mar-13 5:16am View    
yes its what i mean
DARSANA K 13-Mar-13 5:14am View    
Deleted
i want
amount(sum amount of e)|amount(sum amt of d)
--------------------------------
|
DARSANA K 12-Mar-13 8:01am View    
it wont give correct answer