No products in the cart.

Differentiate between where and order by …

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Install Now

Differentiate between where and order by clause of select statement with example

Posted by Kanisha Goyal 4 years ago

CBSE > Class 10 > Information Technology (402)

2 answers

Kanisha Goyal 3 years, 11 months ago

Is where and group by same thing??

1Thank You

Gaurav Seth 4 years ago

<th>BASIS FOR COMPARISON</th> <th>GROUP BY</th> <th>ORDER BY</th>

Basic	Group By is used to form the Group of the set of the tuples.	Order By is used to arrange the data obtained as a result of a query in Sorted form.
Attribute	Attribute under Aggregate function can not be in Group By clause.	Attribute under aggregate can be in Order By Clause.
Ground	Done on the ground of similarity among attribute values.	Done on the ground of ascending order and descending order.

0Thank You

ANSWER

Related Questions

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, 3 weeks ago

CBSE > Class 10 > Information Technology (402)

1 answers

Why is it important to overcome communication barriers?

Posted by Pavi S 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

What is style and formatting window?

Posted by Account Deleted 2 months, 1 week 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

Communication should maintain ______in it's objectives

Posted by Manyata Mishra 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 Hardika . 2 months, 2 weeks ago

CBSE > Class 10 > Information Technology (402)

0 answers

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)