SQL-OracleFunctions-Page19

-

                                                                                             


👉Oracle Functions

✅Select AVG(CURBAL) "Average Balance"  from  ACCT_MSTR

✅Select MIN(CURBAL) "Minimum Balance" from  ACCT_MSTR

✅COUNT(expr)
Returns the number of rows where expr is not null.
Select COUNT(ACCT_NO) "No. of Accounts" from ACCT_MSTR

✅COUNT(*)
Returns the number of rows in the table, including duplicates and those with nulls.
Select COUNT(*) "No. of Records" from ACCT_MSTR

✅Max
Returns the maximum value of expression.
Select Max(CURBAL) "Maximum Balance" from ACCT_MSTR

✅Sum
Returns the sum of values.
Select Sum(CURBAL) "Total Balance" from ACCT_MSTR

✅Coalesce
Below query returns FNAME as CustomerName if FNAME is not null, in case FNAME is null, it returns CUST_NO as CustomerName, i.e. it returns the first not null value from the expression.

Select Coalesce(FNAME, CUST_NO) CustomerName from CUST_MSTR

Comments

Post a Comment

Popular posts from this blog

SQL-ForeignKeyConstraint-Page6

-
Image
                                                                              👉 Foreign Key Constraint Foreign Key represent relationships between tables. A foreign key is a column or group of columns whose values are derived from the primary key or unique key of some other table. ✅ The table in which the foreign key is defined is called Foreign table or Detail table. ✅ The table that defines the primary or unique key and is referenced by the foreign key is called the Primary table or Master table. 👉 Features 1)Master table cannot be updated if child records exists. 2)Records cannot be inserted or deleted into a detail table if corresponding records in the master table do not exist. 3)Records of the master table cannot be deleted if corresponding records in the detail table already exist. 👉 O...
Read more

Javascript-OOPs(Part3)-Inheritance - (9)

-
Image
   👉 Javascript with OOPs (Inheritance) In Javascript, Inheritance is done using prototype object. A prototype object is an object pointing to another object. We don't have a direct inheritance in Javascript, we can mimic inheritance using prototype. Let's say, we have one more class that inherits from Customer, and it submits to Server2. function CustomerChild(){         this.submit = function() {         alert ("this submits the data to Server2" + " "      +  this.CustomerName + " "                                       + this.CustomerCode");   }}             CustomerChild.prototype = new Customer(); var cust = new Customer(); cust.CustomerName ("John"); cust.Submit();  --this is a call to the submit method of the Customer class.  cust = new CustomerChild(); cust...
Read more

OraclePLSQL-Page3

-
Image
                                                                                          👉 Creating a table from a table Below SQL syntax populates the target table with data from the source table. To create a target table without the records from the source table, the SELECT statement must have a WHERE clause. The WHERE clause must specify a condition that cannot be specified. 👉 Inserting data into a table from another table It is used to populate a table with data that already exist in another table. 👉DELETE Command The DELETE command deletes the rows from the table that satisfies the condition and returns the number of records deleted.
Read more