Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Self doubt on SQL
atul_21
asked
in
Databases
Dec 25, 2017
203
views
0
votes
0
votes
The IN clause can be used as multiple AND condition. True or false?? please explain
atul_21
asked
in
Databases
Dec 25, 2017
by
atul_21
203
views
answer
comment
Follow
share this
share
1 comment
by
Ashwin Kulkarni
commented
Dec 25, 2017
reply
Follow
share this
False, IN can be use as multiple OR conditions.
It is same as =ANY or =SOME
2
2
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
0
Answers
← Previous
Next →
← Previous in category
Next in category →
Related questions
0
votes
0
votes
0
answers
1
kd.....
asked
in
Databases
Apr 30, 2019
701
views
Self Doubt on SQL AND operator
Here why does the 5th query select * from employees natural join works_on where PID = 'X' AND PID='Y'; is not working The queries are The output are
kd.....
asked
in
Databases
Apr 30, 2019
by
kd.....
701
views
sql
databases
relational-algebra
0
votes
0
votes
1
answer
2
aditi19
asked
in
Databases
May 9, 2019
461
views
Any good resource for developing concepts on transactions in SQL?
aditi19
asked
in
Databases
May 9, 2019
by
aditi19
461
views
sql
transaction-and-concurrency
databases
3
votes
3
votes
0
answers
3
Balaji Jegan
asked
in
Databases
Jan 30, 2018
836
views
Interesting question on SQL
Consider a database with three relation instances shown below. The primary keys for the Drivers and Cars relation are did and cid respectively and the records are stored in ascending order of these primary keys as given in the tables. No indexing is available in ... If Binary Search is used to locate a tuple in a relation using primary key, then what is the range of n?
Balaji Jegan
asked
in
Databases
Jan 30, 2018
by
Balaji Jegan
836
views
databases
sql
query
binary-search
0
votes
0
votes
0
answers
4
Tuhin Dutta
asked
in
Databases
Dec 15, 2017
413
views
DBMS sql query on null
Student table ROLLNO NAME MARKS1 MARKS2 1 T 50 30 2 S 70 99 3 D NULL 10 NULL NULL 78 NULL NULL NULL NULL NULL a) select count(MARKS1) from student; b) select count(*) from student;
Tuhin Dutta
asked
in
Databases
Dec 15, 2017
by
Tuhin Dutta
413
views
databases
query
sql
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
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
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy