how to get group by and order by in same query

Question

1.00/5 (1 vote)

See more:

SQL

Posted 7-May-15 20:47pm

sekar305

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shivangi_K · Answer 1 · 2015-05-07T20:58:00

You can use the below query

SQL

SELECT
    [ALL | DISTINCT | DISTINCTROW ]
          select_expr [, select_expr ...]
    [FROM table_references
    [WHERE where_condition]
    [GROUP BY {col_name | expr | position}
      [ASC | DESC], ... [WITH ROLLUP]]
    [HAVING where_condition]
    [ORDER BY {col_name | expr | position}
      [ASC | DESC], ...]
    ]

OriginalGriff · Answer 2 · 2015-05-07T21:02:00

You can use GROUP BY and ORDER BY very easily, but...only if you are ordering by one of the columns in the GROUP:

SQL

SELECT Title FROM MyTable
GROUP BY Title
ORDER BY Title DESC

If the column you want to ORDER BY isn't in the GROUP, then that means it can have multiple values for each row the GROUP BY will return and SQL can't sort based on that - because it doesn't know which of the values it should use for sorting.

pradeeppaddu · Answer 3 · 2015-05-07T20:55:00

Solution 1

Hi,

I am giving my solution what i think,

SQL>

Select column_name from Table_name
group by column_name
order by column_name1

Posted 7-May-15 20:55pm

pradeeppaddu

Comments

OriginalGriff 8-May-15 3:03am

Reason for my vote of one: Please check your answers before you post them: that SQL will always give an error:
"Column "Table_name.column_name1" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.

sekar305 8-May-15 3:49am

using sum(column_name) is it possible

OriginalGriff 8-May-15 3:57am

Yes - because that is an Aggregate query which "collapses" all the possible values for the row to a single row. Same with MAX, MIN, COUNT, AVG ...

sekar305 8-May-15 4:00am

pls check this query:

select SUM(credit) as credit ,SUM(debit) as debit,short from balancesheet where status='COMPLETED' order by short (select SUM(credit) as credit ,SUM(debit) as debit from balancesheet where status='COMPLETED' group by header_type)

OriginalGriff 8-May-15 4:07am

Check it for what?

sekar305 8-May-15 4:11am

group by and order by

OriginalGriff 8-May-15 4:13am

It doesn't have GROUP BY and ORDER BY in one query: the GROUP is in a subquery which is independent of the main, ordered SELECT.

how to get group by and order by in same query

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0