Connection Oriented and Connectionless Services

Connection oriented and Connectionless services are the two data transmission services provided by the network layer protocols and transport layer protocols. The Connection oriented services establish a connection prior to sending the packets belonging to the same message from source to the destination. On the other hand, the connectionless service considers each packet belonging to …

Connection Oriented and Connectionless Services Read More »

Aggregate Functions in SQL

Aggregate functions in SQL evaluates the set of tuple values and returns a relation with a single attribute carrying single tuple value as a result. SQL has five aggregate functions count, average, maximum, minimum, sum. Among these aggregate functions, only ‘sum’ and ‘average’ function operate only on numeric values only while count, maximum, minimum can …

Aggregate Functions in SQL Read More »