No products in the cart.

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

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 2 years, 5 months ago

CBSE > Class 10 > Information Technology (402)

1 answers

Omya Aryan 1 year, 5 months ago

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

ANSWER

http://mycbseguide.com/examin8/

Related Questions

What is the need of designing tables?

Posted by Swastik Mishra 11 months, 3 weeks 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 11 months, 1 week ago

CBSE > Class 10 > Information Technology (402)

0 answers

Define goal seek

Posted by Sudharshini Kanthasamy 11 months ago

CBSE > Class 10 > Information Technology (402)

1 answers

Communication should maintain ______in it's objectives

Posted by Manyata Mishra 11 months, 2 weeks ago

CBSE > Class 10 > Information Technology (402)

0 answers

Write appropriate command for list of all files in a directory

Posted by Jatin Jaat 11 months ago

CBSE > Class 10 > Information Technology (402)

0 answers

Benefits of visual communication

Posted by Ayushi Singh 11 months, 1 week 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 7 months, 1 week ago

CBSE > Class 10 > Information Technology (402)

1 answers

What type of feedback should be used for instant feedback

Posted by Sakshi Pradhan 11 months, 3 weeks ago

CBSE > Class 10 > Information Technology (402)

0 answers

What is style and formatting window?

Posted by Account Deleted 11 months ago

CBSE > Class 10 > Information Technology (402)

0 answers

Why is it important to overcome communication barriers?

Posted by Pavi S 11 months ago

CBSE > Class 10 > Information Technology (402)

0 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Google Play

Download myCBSEguide App