If i wanna use variable 'a' for further processing in shell script..wat is to be rectified in the below code

Select *
Count(*) = a
from EMPLOYEE DATA

if [a >100]
..
..
fi

is the above query correct if not what should be done to get the value of count(*)
for further transaction,...