To select range of values between two columns

I have a table which has 4 columns and i want to get a value between two range of values in column .I tried but it returns null.Pls help me to over come the issue.

GradeID | FAMin|FAMax| FAGrade| 1 | 37 | 40 | A1| SELECT * FROM GradeSystems WHERE FAMin >= 38 AND 38 <= FAMax;

-------------Problems Reply------------

Your comparison for FAMin was backwards.

SELECT * FROM GradeSystems WHERE FAMin <= 38 AND FAMax >= 38;

Category:sql Views:5 Time:2018-11-24
Tags: sql sql server

Related post

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.196 (s). 11 q(s)