Write a SELECT statement that uses the SYSDATE function to create a row with the

Question

Write a SELECT statement that uses the SYSDATE function to create a row with these columns:
product_name The product_name column
list_price                       The list_price column
discount_percent          The discount_percent column
discount_amount    A column that’s calculated from the previous two columns
discount_price              A column that’s calculated from the previous three columns

Use the ROWNUM pseudo column so the result set contains only the first 5 rows.
Sort the result set by discount price in descending sequence.

Explanation / Answer

in this row the sequenctial order to perfect of the model

suppose u will be usein some database is created u will cretae database u want show the number of tables easily

and u can easily ain the tables

first u will cretae data base

Syntax:

create database <database name>

it will be storing the data in securable manner after u will create number of tables.

and inserting data in number of fields.

product name listprice discount percentage discount amount dicount price Rice 750 5% 175 675 oil 100 1% 10 90 dall 48 1% 3 45 wheats 50 2% 10 40

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.