1,097 views

1 Answer

0 votes
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 votes
1 answer
1
mukul maurya asked Sep 1, 2018
277 views
0 votes
0 votes
1 answer
2
mukul maurya asked Sep 1, 2018
510 views
0 votes
0 votes
1 answer
3
mukul maurya asked Sep 1, 2018
326 views
0 votes
0 votes
1 answer
4
mukul maurya asked Sep 1, 2018
529 views