How to find the sum that is less than 1000 in oracle?

Member

by darion , in category: MySQL , 4 months ago

How to find the sum that is less than 1000 in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by addison , 4 months ago

@darion 

To find the sum of numbers that is less than 1000 in Oracle, you can use a SQL query like the following:

1
2
3
SELECT SUM(column_name)
FROM table_name
WHERE column_name < 1000;


Replace column_name with the name of the column containing the numbers you want to sum and table_name with the name of the table containing that column. This query will return the sum of all the numbers in the specified column that are less than 1000.