The Gateway to Computer Science Excellence
0 votes
445 views

in Databases by (35 points) | 445 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.

by Active (2.3k points)

Related questions

0 votes
0 answers
1
asked Sep 2, 2018 in Databases by mukul maurya (35 points) | 71 views
0 votes
0 answers
2
asked Sep 2, 2018 in Databases by mukul maurya (35 points) | 73 views
0 votes
1 answer
3
asked Sep 2, 2018 in Databases by mukul maurya (35 points) | 52 views
0 votes
1 answer
4
asked Sep 2, 2018 in Databases by mukul maurya (35 points) | 96 views
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,292 answers
198,217 comments
104,906 users