Friday , June 21 2024

SIGN Function in SQL Server(TSQL)


The SIGN function determines whether a number is negative, 0, or positive.

If the number is negative, it returns -1,

If the number is 0, it returns 0,

If the number is positive, it returns +1

Look at the example;


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *