SQL PHP HTML ASP JavaScript articles and free scripts to download

SQL Home > Date Math String PHP MySQL

sign sql

We can get the sign of the data by using sign function. Here is an example

select sign(-4.5); Output -1
select sign(+4.5); Output 1
select sign(4.5); Output 1

If we try a sting we will get 0 as output

select sign('abc'); // Output 0

avg:Getting average of data in MySQL

sum:Sum of a range of data in MySQL

sum of multiple columns in MySQL & to get Percentage and total

min:Getting the Minimum value of data in MySQL

max:Getting the Miximum value of data in MySQL

mod:Getting the reminder of a division by using Mod function

Getting second highest number from the student table

format: Formatting MySQL data in a query while managing records of a table

floor: MySQL function to get highest integer lower than the input value

ceil: MySQL function to get lowest integer higher than the input value

abs: MySQL abs function to get absolute value

round: MySQL round function to get rounded value from column

sign: MySQL sign function to get sign of numbers

conv: MySQL conv to convert numbers from one base to other

oct: MySQL oct to convert numbers from decimal to Octal system

truncate: MySQL truncate function to remove decimal places

sqrt: square root of number by sqrt function

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email	( not to be displayed)Privacy Policy
1+2=	This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



Join Our Email List Email:

For Email Newsletters you can trust

MySQL Math

Math Functions sum sum Percentage average ceil floor Minimum Maximum Mod 2nd Highest Formatting abs round sign conv oct Truncate sqrt

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2013 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer