search
Log In
0 votes
703 views

in Databases 703 views

1 Answer

0 votes

In operator is used to choose among a value set

like IN (1,2,3,4)  etc

BETWEEN is used for range.

e.g. List all the Employee Fname, Lname who is having salary between 30000 and 45000.

SELECT Fname, Lname
FROM Employee
WHERE Salary
BETWEEN 30000 AND 45000;

Answer : D as per syntax.

Related questions

0 votes
0 answers
1
103 views asked Sep 2, 2018 in Databases mukul maurya 103 views
0 votes
1 answer
2
173 views asked Sep 2, 2018 in Databases mukul maurya 173 views
0 votes
1 answer
3
106 views asked Sep 2, 2018 in Databases mukul maurya 106 views
0 votes
1 answer
4
187 views asked Sep 2, 2018 in Databases mukul maurya 187 views
...