What is the differnce between Order by and Group by

Answer Posted / guest

Order by is to sort the output records based on some
columns and group by is to group the records and to apply
aggregate functions on the particular columns

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain various types of locks in a transaction? Which is better and why?

599


What is the difference between specialization and generalization?

574


aht is the difference b/w network & hierarchial & relational dbms????

1771


After normalization, what are the conditions which have to keep in mind to de-normalize it?

614


what is transaction state, buffer management, shadow paging

2926






What is difference between data and database?

550


What is ase database?

553


How many types of normalization? What is the use of it?

616


What is relational database with example?

541


What is the best database?

520


How to implement database security?

535


How many types of locks are present in a database?

605


What are the most common databases?

540


Explain inner and outer joins with examples.

710


When should you not use firebase?

607