In SQL what is the difference between ORDER BY clause and GROUP BY clause ?

02 February 2018 1 211 Report

In RDBMS, What does "Group by" clause do in the columns of a table ?

Dear Murari,

The ORDER BY clause's purpose is to sort the results by specific columns in acceding or descending order. On the other hand, GROUP BY is used in conjunction with aggregate functions like SUM, MAX, MIN, AVG, COUNT etc. To further assist you bellow you can find an example for both commands:

TABLE:

ID NAME

1 Peter

2 John

3 Greg

4 Peter

SELECT * FROM TABLE ORDER BY NAME

3 Greg

2 John

1 Peter

4 Peter

SELECT Count(ID), NAME FROM TABLE GROUP BY NAME

1 Greg

1 John

2 Peter

SELECT NAME FROM TABLE GROUP BY NAME HAVING Count(ID) > 1

Peter

Badges
Science topic

Similar topics
Analytical Chemistry
Column

More Murari Kumar's questions See All

Can I publish my M.Sc. thesis in a journal ?

Is it ok to publish my M.Sc. research work in any related journal or I am going to violate Plagiarism rule ? Kindly suggest.

04 May 2018 4,109 1 View

What makes a person a true researcher ?

How to become a good researcher ? What the real researchers think ? What the real researchers actually do ? Suggestions invited...

01 February 2018 8,783 11 View

What is Fuzzy logic and Crisp Logic ?

The term Fuzzy is new for me. So kindly suggest some good source to learn the concept. (Also, it should include some examples and numericals).

01 February 2018 4,594 0 View

No title

I want to analyse post/content of few previous years data on a particular subject. So is there any tools available ? Kindly suggest if any...

01 February 2018 6,619 7 View

Whether agricultural universities should have advanced computer Education or not ?

With the increasing importance and implementation of computer applications in modern agriculture, Should Agricultural universities make thier students sufficient in advanced computer knowledge or...

01 February 2018 2,659 4 View

Before entering in the vast and advanced world of Soft computing, What are the prerequisites for a new comer ?

For a new comer like me in the field of computer science, I have just superficial knowledge of Soft-computing (Like ANN, Machine learning, Fuzzy logic etc.) I want to be familiar with these topics...

01 February 2018 4,070 4 View

In PHP how can we scrap or harvest data from websites ?

How to extract website content of HTML pages ?

31 December 2017 7,983 7 View

What is the minimum range or size of big data? When the data of relation database become a Big Data? Which technology can be used for small Big Data ?

We usually listen that Big Data is very big to handle. I just want to know when will normal data become big data ? (In terms of size viz. MB/GB/TB) ? Please explain.

11 December 2017 4,109 4 View

Buffer Exchange using column packed with sephadex G-25 effect on protein concentration?

Hello, If i am doing a buffer exchange for an antibody of 1mg/mL, does the elution lose protein in the process of buffer exchange? For example, if i flow through 500 uL of 1mg/mL sample, and...

03 March 2021 6,299 3 View

No title

03 March 2021 5,360 2 View

Which is suitable for use with Python? MySQL or SQL Server?

Which is suitable for use with Python? MySQL or SQL Server? What is your suggestion?

01 March 2021 3,422 3 View

How can we raise the figure when we writing a paper with Latex ?

Hi, everyone. I'm a starter to write a paper by Latex. But I have some difficulty using it. I'm writing the paper with 2 columns. And, there is one figure that occupies the 2 both-sides. I want to...

26 February 2021 3,738 3 View

What is the best way to calculate the angles of twist for concrete columns subjected to torsional moment using finite element software?

In Finite element software like ANSYS , there is difficulty in obtaining direct results of twisting of concrete members because SOLID65 which is the unique element designed to represent concrete...

26 February 2021 3,806 2 View

Compute for the total volume of concrete needed for the concrete pouring of the foundation including its column up to NGL only as shown in the plan?

Looking for the quantity of cement, sand, and gravel of footings and columns. Thank you!

25 February 2021 3,092 2 View

No amplification data for qPCR on MxPro?

I have set up a qPCR run on MxPro with SYBR green and ROX as a reference, however, when I go to the analysis section the program seems to only collect data for the dissociation curves and not the...

25 February 2021 8,039 1 View

Can I use TCA instead of TFA for protein analyis in RP-HPLC?

I am trying to analyze lipase using the reverse phase-HPLC C18 column. In the literature, 0.1 % TFA was and 60% ACN was used. Can I use TCA in place of TFA? If any other methods are available to...

25 February 2021 2,388 3 View

Can I use acetic acid with an ELITE WAX Perkin Elmer column for Gas Chromatography?

Hi! I would want to know if I can use acetic acid with an ELITE WAX Perkin Elmer column for Gas Chromatography. This column has a polyethylene glycol phase, but I can't find the manual to check...

22 February 2021 730 2 View

My silica gel column dried can I somehoe save the trapped matter?

I tried to separate my substance from a protein in a sillica gel column. By mistake, it dried and cracked. Can I save the trapped substance? Can I repack it ,or at least elute all of the trapped...

22 February 2021 1,789 3 View