Monday, November 13, 2017

Find out all negative and positive value separately from a table field

Find out all positive value by sql.

SELECT  number as   negativevalue FROM  Table WHERE ( number< 0)

Find out all negative value by sql.

SELECT  number as positivevalue FROM  Table  WHERE ( number< 0)

No comments:

Post a Comment