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

Member

by darion , in category: MySQL , a year ago

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

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by addison , a year 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.

Related Threads:

How to insert 1000 rows into an oracle database?
How can find sum of a column after group by result in mysql?
How to get sum of count of the columns in oracle?
How to display the total sum of all individual dates in oracle?
How to assign groups based on sum of values in oracle?
How to find the most repeat data in oracle?