i have marks in table,how to find total?

Question Posted / dinesh

i have marks in table,how to find total?..

Answer / jayasankar addanki

SELECT sum(field_name) from tablename

Ex: SELECT sum(marks) from students

Is This Answer Correct ?

12 Yes

0 No

More Oracle AllOther Interview Questions

the user should know to which database he is connected currently in oracle

default triggers available for reports

Name three advisory statistics you can collect.

A scenario for amount correction & how to use amount correction functionality in AP invoices

How would you determine who has added a row to a table?

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

When creating a user, what permissions must you grant to allow them to connect to the database?

What is autocashrule set? : oracle accounts receivable

What is auto invoicing? Explain : oracle accounts receivable

Explain prerequisites and post activities of oracle database installation

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

For more Oracle AllOther Interview Questions Click Here