-
sum a column without last record inteo text item
Hello,
in a form is the table scott.emp displayed with an additional column lfdnr
with the entries 0,1,2,...,13 (with the scott.emp having 14 records)
How can the sum of the column emp.sal be displayed in another text item
but the value of emp.sal of the last record should not be included in the summmation
SELECT SUM(EMP.SAL)
WHERE LFDNR <> MAX(LFDNR)
Sincerely
-
Can you define the criteria for the last record?
Tamil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|