search
Log In
0 votes
701 views

in Databases 701 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
172 views asked Sep 2, 2018 in Databases mukul maurya 172 views
0 votes
1 answer
3
106 views asked Sep 2, 2018 in Databases mukul maurya 106 views
0 votes
1 answer
4
186 views asked Sep 2, 2018 in Databases mukul maurya 186 views
...