is it necessary to write group by and order by clause together

Question Posted / pinku325

3 Answers
10962 Views
HCL, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

is it necessary to write group by and order by clause together..

Answer / guest

No it is not necessary.

Is This Answer Correct ?

36 Yes

2 No

is it necessary to write group by and order by clause together..

Answer / suman

No Required.

Group by is grouping the records

but Order by mention the data should be desc or asc order.

Is This Answer Correct ?

0 Yes

0 No

is it necessary to write group by and order by clause together..

Answer / madhav

yes,
select deptno,sum(sal) from emp group by deptno;
(it displays ascending order)
when we want to display the descending order,we need order
by clause and group clause.
select deptno,sum(sal) from emp group by deptno order by
deptno desc
(it displays the descending order)

Is This Answer Correct ?

9 Yes

10 No

Post New Answer

More SQL PLSQL Interview Questions

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers IBM, TCS,

Why do we use procedures in sql?

0 Answers

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers

How does stored procedure reduce network traffic?

0 Answers

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers

What is the difference between numeric and autonumber?

0 Answers

what is the difference between delete and truncate commands? : Sql dba

0 Answers

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers Pitney Bowes,

How to disable a trigger name update_salary?

0 Answers

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers CGI,

Can a foreign key be a duplicate?

0 Answers

How much does sql cost?

0 Answers

For more SQL PLSQL Interview Questions Click Here