SQL Tutorial - 15: Arithmetic Operators

In this tutorial we'll talk about operators in general and specifically about the five arithmetic operators available in SQL.

[hannahrosereviews]

I am so thankful for this video!!! Without this tutorial I wouldn't have passed my Computer Class! Literally crying tears of joy!

[McGavel]

Cool, thanks! It was cool to get an intro to the command line.

[MrYunussalman]

your videos are very useful dude, thank you so much

[Anushka-ra]

U can improve ur thumbnail of video for gaining more likes or viewss..btw ur all videos are awesome crystal clear understanding..❤

[botrrun]

I am using Oracle Database Express, It does not let me use the operators the way you were able to at the command line.

[harikan]

Why we are using SELECT command to perform arthimetic operations?

[mohit]

Hello, i really loved all your videos, although i couldnt get to use the workbench gui tool i have been using the cmd prompt and ur videos are really informative. I hv liked all your videos. Could you do me and all subscribers a favour and make a list of all the command posted up till now. Thanking you in advance and regards mohit

[shaikmuzeef]

SELECT 10+20; FROM KEY WORD not found where expected SAYING what can i do

[Mrlittlekaiju]

All the command which are used in workbench can also work in command line

[GideonAbutu]

Hello, are you there?
I am new to SQL/Database, will this be a good start for me?

Thankyou

[abelincolnparth]

My interest is in using arithmetic operators on columns to make a result in new column.
In LibreOffice I have no problem doing that, but I want to name the new column, not have the formula appear in the new column heading.  I tried the AS operator but I get a syntax error.

[akshayverma]

Please confirm me where i am wrong

USE test;
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1000, 'Jatin', 001, '1992-07-16 13:50:15', 'Math', 'Sanskrit');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1001, 'Ram', 002, '1992-08-16 14:50:15', 'English', 'Hindi');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1002, 'Jai', 003, '1992-09-16 15:50:15', 'Hindi', 'Social');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1004, 'Shyam', 004, '1992-10-16 13:40:15', 'Math', 'Sanskrit');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1005, 'Jain', 005, '1993-07-16 09:50:15', 'Geography', 'None');

INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1006, 'Ram', 006, '1993-10-10 08:50:15', 'History', 'Physical');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1007, 'Rahim', 007, '1992-07-10 02:50:15', 'Hindi', 'None');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1008, 'Sachin', 008, '1992-07-29 01:50:15', 'English', 'None');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1009, 'Saurav', 009, '1994-07-16 00:50:15', 'English', 'Physical');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1010, 'Raefel', 010, '1994-07-16 01:50:15', 'English', 'Computer');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1011, 'Roger', 011, '1982-07-16 03:50:15', 'English', 'Social');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1012, 'Sehwag', 012, '1992-01-16 13:50:25', 'Geography', 'Computer');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1013, 'Gautam', 013, '1987-07-16 13:20:15', 'Geography', 'Computer');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1014, 'Zaheer', 014, '1993-07-06 13:50:15', 'Computer', 'Geography');
INSERT INTO employee (rollnumber, name, id, dob, pass, fail)
VALUES (1015, 'Harbhajan', 015, '1993-07-01 16:50:15', 'Geography', 'Computer');

;

[hanialbarni]

how to get the modular operation from keyboard ?

[sarvariabhinav]

MAN PLEASE GET A DECENT MIC...BEST TUTORIALS THOUGH.

[VirendraBG]

Hey which screen recording software you have used?

[ElisandroDeLeon]

Not sure how to get to my command line client..hmm