I have a employee table with EMPID, EMPNAME, DEPTID, SAL
and want to fetch the maximum and minimum salary on each
dept id with the emp name. Can anyone help in this? The
result should contain the EMPNAME, DEPTID, SAL.
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
If invoice amout upto 25,000 pay from 1st bank,
invoice amount 25,001 to 50,000 pay from 2nd bank,
invoice amount 50,001 to 1,00,000 from 3rd bank,
How can you configure through Automatic Payment