Geography, asked by sneha9994, 5 months ago

differentiate order by and group by with an example.

Answers

Answered by kaviramesh203

Explanation:

ORDER BY alters the order in which items are returned.

GROUP BY will aggregate records by the specified columns which allows you to perform aggregation functions on non-grouped columns (such as SUM, COUNT, AVG, etc). ORDER BY: sort the data in ascending or descending order.

Answered by ValtAoiBeybladers

Answer:

hope my helped you

Explanation:

ORDER BY alters the order in which items are returned. GROUP BY will aggregate records by the specified columns which allows you to perform aggregation functions on non-grouped columns (such as SUM, COUNT, AVG, etc). ORDER BY: sort the data in ascending or descending order

Previous Question

Next Question

Similar questions

Math, 2 months ago

(12-(1-7)+1)×(42-53-(-6)) using BODMAS rule...

Math, 2 months ago

chavvi has to make a science project for which she needs 360 I've cream stick, she buys 40 packs of ice cream stick. There are 100 sticks in each packs. How many more/less ice cream stick does she has?

Math, 2 months ago

Suppose that the price of a commodity after x years is given by f(x) = Aekx where A and k are constants. ) 1. Find A and k when f(0) = 4 and f0(0) = 1. In this case, what is the price after 5 years? (Do not solve for e^x or ln(x)) 2. We assume now that A = 4 and k = 0:25. When the price has in- creased to 18, it becomes controlled so that the annual price increases is limited to 10%. When...

Math, 5 months ago

Gas cylinders are not weighed accurately. On complaint, 10 specimen cylinders were taken from a godown at random. Following are the observations (given in picture) Find the probability that a cylinder selected at random weighs more than 30kg ...

Science, 5 months ago