No products in the cart.

Is there any priority for order …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Is there any priority for order by and where clause. Like if q. Says display details of all customers having age>30 in asc order of age. Then which is correct or both correct÷ SELECT * FROM CUSTOMERS WHERE AGE <30 ORDER BY AGE ASC; SELECT * FROM CUSTOMERS ORDER BY AGE ASC WHERE AGE <30;

Posted by Devansh Raghav 5 years, 4 months ago

CBSE > Class 12 > Computer Science

1 answers

Prachi Jain 5 years, 4 months ago

1st one is correct....

ANSWER

http://mycbseguide.com/examin8/

Related Questions

Write a python program to count threwords in a given file

Posted by Hanni Pham 1 year, 1 month ago

CBSE > Class 12 > Computer Science

1 answers

Write a python program to count three letter words in a given file

Posted by Hanni Pham 1 year, 1 month ago

CBSE > Class 12 > Computer Science

0 answers

A Railway company uses machines to sell tickets. The machine details and daily sales information are recorded in two tables: Table Name: Machine Table Name: Sales The primary key of the table Machine is Machine_ID. Records in the table Sales are uniquely identified by the fields Machine_ID and Date. (a) Create the tables Machine and Sales. (b) Write a query to find the number of ticket machines in each station. (c) Write a query to find the total ticket income of the station “New Delhi” of each day. (d) Write a query to find the total number of tickets sold by the machine (Machine_ID = 122) till date.

Posted by Parveen Singh 1 year, 5 months ago

CBSE > Class 12 > Computer Science

0 answers

1.1. In a table in MYSQL database, an attribute A of datatype varchar(20) Nes the value "Keshar The attribute S of datatype char(20) has value "Meenakshi". How many characters are occupied by attribute A and attribute 67 a. 20,6 6.6,20 ८. 9,6 d. 6,9

Posted by Account Deleted 1 year, 2 months ago

CBSE > Class 12 > Computer Science

0 answers

Which book do you all follow for cs? How many chapters are there in the syllabus

Posted by Priya Shukla 1 year, 3 months ago

CBSE > Class 12 > Computer Science

1 answers

Differentiate between function and argument

Posted by Prawar Narang 1 year, 4 months ago

CBSE > Class 12 > Computer Science

1 answers

What is mean by buffering in file handling?

Posted by Syedali Fathima 1 year, 3 months ago

CBSE > Class 12 > Computer Science

1 answers

Your school has a document enlisting names of school students who have pass this year and taken admission in further courses. You have to edit the documents with the following changes: a) Find the word ‘utilitarian‘ and replace it with the word ‘pragmatic’ (Take care not to replace the word utilitarianism). b) The word college as it occurs in the text should be capitalize. Replace the word college with the correct capitalization i.e with College throughout the text using the appropriate option.

Posted by Anju Sharma 1 year, 2 months ago

CBSE > Class 12 > Computer Science

0 answers

What are called tokens

Posted by Kandeepan Jothivel 1 year, 4 months ago

CBSE > Class 12 > Computer Science

2 answers

Write a program in python to accept a number and check whether the number is divisible by 3 as well as 5 otherwise decide : (a) Is the number divisible by 3 and not by 5 (b) is the number divisible by 5 and not by 3 (c) is the number neither divisible by 3 or by 5

Posted by Manu Singh 1 year, 4 months ago

CBSE > Class 12 > Computer Science

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