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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is sql database stored?

687


What is bulk compiling in pl/sql.?

798


What is group by in sql?

748


what is the difference between nested subquery and correlated subquery?

746


what is cross join? : Sql dba

742






What is nvarchar in sql?

715


Can you do multiple joins in sql?

728


What is a stored procedure in sql with example?

784


what does the t-sql command ident_current does? : Transact sql

734


How do you remove duplicates without using distinct in sql?

695


Is like operator in sql case sensitive?

731


Mention what is the function that is used to transfer a pl/sql table log to a database table?

662


What are the disadvantages of file system?

825


How to order siblings in oracle hierarchy queries?

771


How many subqueries can be nested in a statement?

691