To sort a result, use an ORDER BY clause.
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if any).
ORDER BY [col1],[col2],.[coln]; Tells DBMS according to what columns it should sort the result. If two rows will have the same value in col1 it will try to sort them according to col2 and so on.
GROUP BY [col1],[col2],.[coln]; Tells DBMS to group (aggregate) results with same value of column col1. You can use COUNT(col1), SUM(col1), AVG(col1) with it, if you want to count all items in group, sum all values or view average.

EIGRP employs four key technologies, including neighbor discover/recovery, Reliable Transport Protocol (RTP), Diffusing Update ALgorithm (DUAL) finite-state machine, and a modular architecture that enables support for new protocols to be easily added to an existing network.

Each SCSI device in a chain must have a unique ID number assigned to it. Even though there are a total of eight possible SCSI ID numbers for each controller, only six are available for use with external devices. If two SCSI devices are set to the same ID number, one or both will appear invisible to the system.

Use DISK RESIZE.

The interviewer who asks this question wants to discover if you are flexible, enjoy working in a team environment, have experience in this area, and what your viewpoints are on the subject.

The process of assigning the IP addresses by the DHCP server known as DORA (Discover, Offer, Request, and Acknowledgement).