DIV is used to perform
integer division on numbers.
Example
5 DIV 2
mysql> SELECT 56 DIV 33; +-----------+ | 56 DIV 33 | +-----------+ | 1 | +-----------+ 1 row in set (0.00 sec) mysql> SELECT 56 DIV 3; +----------+ | 56 DIV 3 | +----------+ | 18 | +----------+ 1 row in set (0.00 sec)
I am going to use following
sample data.
CREATE TABLE employee(
id int PRIMARY KEY,
firstName VARCHAR(20),
lastName VARCHAR(20),
salary DECIMAL(10, 2)
);
INSERT INTO employee VALUES
(1, "Hari Krishna", "Gurram", 12345.67);
INSERT INTO employee VALUES
(2, "Rama Devi", "Gurram", 1234578.67);
INSERT INTO employee VALUES
(3, "Lakshmana", "Rao", 9876543.67);
INSERT INTO employee VALUES
(4, "Rama", "Krishna", 1234587.67);
INSERT INTO employee VALUES
(5, "Sowmya", "asd", 1238745.67);
INSERT INTO employee VALUES
(6, "Jyotsna", "PS", 76543.67);
INSERT INTO employee VALUES
(7, "Gireesh", "Amara", 87698);
INSERT INTO employee VALUES
(8, "Sravani", "Nidamanuri", 987654);
INSERT INTO employee VALUES
(9, "Saranya", "Amara", 1987654);
mysql> SELECT * FROM employee; +----+--------------+------------+------------+ | id | firstName | lastName | salary | +----+--------------+------------+------------+ | 1 | Hari Krishna | Gurram | 12345.67 | | 2 | Rama Devi | Gurram | 1234578.67 | | 3 | Lakshmana | Rao | 9876543.67 | | 4 | Rama | Krishna | 1234587.67 | | 5 | Sowmya | asd | 1238745.67 | | 6 | Jyotsna | PS | 76543.67 | | 7 | Gireesh | Amara | 87698.00 | | 8 | Sravani | Nidamanuri | 987654.00 | | 9 | Saranya | Amara | 1987654.00 | +----+--------------+------------+------------+ 9 rows in set (0.00 sec)
Get only integer part of
employee salaries.
mysql> SELECT (salary DIV 1) as "Employee Salary" FROM employee; +-----------------+ | Employee Salary | +-----------------+ | 12345 | | 1234578 | | 9876543 | | 1234587 | | 1238745 | | 76543 | | 87698 | | 987654 | | 1987654 | +-----------------+ 9 rows in set (0.00 sec)
No comments:
Post a Comment