Day: February 1, 2022

SQL DATABASES -SQL GROUP BY The GROUP BY clause is usually used with an aggregate function (COUNT, SUM, AVG, MIN, MAX). It groups the rows by a given column value (specified after GROUP BY) then calculates the aggregate for each Read More …

MULTIPLE CONDITIONS IN SQL DATABASES You can use more than one condition to filter. For that, we have two logical operators: OR, AND. SELECT * FROM table_name WHERE column1 != ‘expression’ AND column3 LIKE ‘%xzy%’; This query returns every column Read More …

DATA TYPES IN SQL In SQL we have more than 40 different data types. But these seven are the most important ones: 1. Integer. A whole number without a fractional part. E.g. 1, 156, 2012412 2. Decimal. A number with Read More …

Logistics Management Information Systems A logistics management information system (LMIS) is a system of records and reports – whether paper-based or electronic – used to aggregate, analyze, validate and display data (from all levels of the logistics system) that can Read More …

CLOCK SYNCHRONIZATION Every computer needs a timer mechanism (called a computer clock) to keep track of current time and also For various accounting purposes such as calculating the time spent by a process in CPU utilization, disk I/O and so Read More …

The performance management system should provide benefits to both the employee and to the organization. For the individual, the appraisal should provide a management information system for making management decision as well as a toll for improving performance. Today’s organization Read More …