No products in the cart.

  1. Homework Help
  2. CBSE
  3. Class 10
  4. Information Technology (402)

Consider the following table: SalesSale_IdProd_NamePriceDiscount1101Laptop6500025001103Pen tab2950010001105Desktop5000015501106Printer120002000 …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Install Now
Consider the following table: SalesSale_IdProd_NamePriceDiscount1101Laptop6500025001103Pen tab2950010001105Desktop5000015501106Printer120002000 How many fields and records are there in Sales table? Write SQL commands for the following: Display Sales ID and price of all products whose discount is more than 1000. Display the details alphabetically by product name. Display product name and sales price after deducting the discount from the price. Note: Sales price can be calculated as (price-discount)

    • Posted by Amanpreet Kaur 1 year, 8 months ago

    CBSE > Class 10 > Information Technology (402)
    • 1 answers

    Omya Aryan 8 months, 1 week ago

    1.SELECT SALES_ID AND PRICE FROM SALES WHERE 'DISCOUNT>1000';

    3Thank You

    ANSWER
    http://mycbseguide.com/examin8/

    Related Questions

    Write appropriate command for list of all files in a directory

    • Posted by Jatin Jaat 2 months ago

    CBSE > Class 10 > Information Technology (402)
    • 0 answers
    This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

    Few rules to keep homework help section safe, clean and informative.
    • Don't post personal information, mobile numbers and other details.
    • Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
    • Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
    • Ask specific question which are clear and concise.

    Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

    Posted by Hardika . 2 months, 2 weeks ago

    CBSE > Class 10 > Information Technology (402)
    • 0 answers
    This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

    Few rules to keep homework help section safe, clean and informative.
    • Don't post personal information, mobile numbers and other details.
    • Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
    • Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
    • Ask specific question which are clear and concise.

    Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

    Posted by Ritik Sirohi 2 months, 2 weeks ago

    CBSE > Class 10 > Information Technology (402)
    • 0 answers
    Benefits of visual communication

    • Posted by Ayushi Singh 2 months, 1 week ago

    CBSE > Class 10 > Information Technology (402)
    • 0 answers
    What is style and formatting window?

    • Posted by Account Deleted 2 months ago

    CBSE > Class 10 > Information Technology (402)
    • 0 answers
    A teacher has made for spreadsheet containing marks of class 10th for unit test unit test 2nd half yearly and annual examination he has to prepare sheet that contain total marks of all the exam of his class Name the option used to perform this task

    • Posted by Ak R 2 months, 2 weeks ago

    CBSE > Class 10 > Information Technology (402)
    • 1 answers
    Communication should maintain ______in it's objectives

    • Posted by Manyata Mishra 2 months, 2 weeks ago

    CBSE > Class 10 > Information Technology (402)
    • 0 answers
    Why is it important to overcome communication barriers?

    • Posted by Pavi S 2 months ago

    CBSE > Class 10 > Information Technology (402)
    • 0 answers
    What is the location in the base interface of the link to create a table using wizard

    • Posted by Chandan Kedia 2 months, 1 week ago

    CBSE > Class 10 > Information Technology (402)
    • 0 answers
    Define goal seek

    • Posted by Sudharshini Kanthasamy 2 months ago

    CBSE > Class 10 > Information Technology (402)
    • 1 answers

    myCBSEguide App

    myCBSEguide

    Trusted by 1 Crore+ Students

    Install Now

    Test Generator

    Test Generator

    Create papers online. It's FREE.

    Try Now

    CUET Mock Tests

    CUET Mock Tests

    75,000+ questions to practice only on myCBSEguide app

    Install Now
    Google Play

    Download myCBSEguide App

    All Courses

    Other Websites

    CBSE Courses

    Resources

    Corporate

    NCERT Solutions

    CBSE Sample Papers

    All Content and Intellectual Property is under Copyright Protection | myCBSEguide.com ©2007-2024