SQL_IN_Query

Question

SQL_IN_Query

Anand. asked Aug 16, 2018

932 views

See all

2 Answers

See all

Related questions

Deprecated: Implicit conversion from float-string "1708108218.847" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 796

Deprecated: Implicit conversion from float-string "1708108218.847" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 801

Deprecated: Implicit conversion from float-string "1708108218.847" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 802

Deprecated: Implicit conversion from float-string "1708108218.847" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 803

Deprecated: Implicit conversion from float-string "1707099170.825" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 796

Deprecated: Implicit conversion from float-string "1707099170.825" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 801

Deprecated: Implicit conversion from float-string "1707099170.825" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 802

Deprecated: Implicit conversion from float-string "1707099170.825" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 803

Deprecated: Implicit conversion from float-string "1707077981.115" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 796

Deprecated: Implicit conversion from float-string "1707077981.115" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 801

Deprecated: Implicit conversion from float-string "1707077981.115" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 802

Deprecated: Implicit conversion from float-string "1707077981.115" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 803

Deprecated: Implicit conversion from float-string "1707077944.941" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 796

Deprecated: Implicit conversion from float-string "1707077944.941" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 801

Deprecated: Implicit conversion from float-string "1707077944.941" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 802

Deprecated: Implicit conversion from float-string "1707077944.941" to int loses precision in /var/www/html/qadb/qa-include/app/format.php on line 803

826

views

2 answers

0 votes

Arjun asked Feb 16

826 views

GATE DS&AI 2024 | Question: 21

Consider the following two tables named Raider and Team in a relational database maintained by a Kabaddi league. The attribute ID in table Team references the primary key...

Arjun

826 views

Arjun asked Feb 16

282

views

0 answers

4 votes

GO Classes asked Feb 5

282 views

GO Classes Test Series 2024 | Mock GATE | Test 14 | Question: 40

Consider the following schema (primary keys are underlined):Which of the following queries returns the department numbers of those departments for which there are no cour...

GO Classes

282 views

GO Classes asked Feb 5

157

views

0 answers

0 votes

GO Classes asked Feb 4

157 views

Memory Based GATE DA 2024 | Question: 17

Consider the following SQL query:\[\begin{aligned}&\text{SELECT * FROM Raider, Team} \\&\text{WHERE Raider.id = Team.id} \\&\text{AND City = 'Jaipur'} \\&\text{AND Raid_p...

GO Classes

157 views

GO Classes asked Feb 4

120

views

0 answers

0 votes

GO Classes asked Feb 4

120 views

Memory Based GATE DA 2024 | Question: 58

DBMS question: One SQL query is given. Based on the query which data structure can be used involving hashing, B+ tree, etc?

GO Classes

120 views

GO Classes asked Feb 4

It will be error because in the query it us asked where manager in (null, null,null) but eid which is a primary key cannot be null.even if we consider ename as primary key, still this field cannot be null. — Bhagyashree Mukherje, Aug 16, 2018
there is no primary key in this relation.We can have a relation without primary key! — Anand., Aug 16, 2018
I had misconception that a relation must have primary key.Thanks for rectifying. — Bhagyashree Mukherje, Aug 16, 2018
i ran this query on WESCHOOLS by creating the same table and using the same query. ----> output : no result.

and this is same output that is shown when it does not matches to any of the values in IN.

I think it should be 0 rows because both condition gives the same output either with null or other case. — arvin, Aug 16, 2018
@arvin can u give the link?

eno generally a primary key right? — srestha, Aug 16, 2018
@srestha mam : its w3schools. what i did was i created a table than inserted 3 same records and than ran the query...

yes eno or ename can also be considered. — arvin, Aug 16, 2018
@anand,

How a relation in RDBMS exist with out a primary key... — Shaik Masthan, Aug 16, 2018
Noo. .Unique key may contains NULL but primary key doesn't have NULL — Shaik Masthan, Aug 16, 2018
https://stackoverflow.com/questions/3459429/is-a-primary-key-necessary-in-sql-server

See we can create it, but creation of this is just useless — srestha, Aug 16, 2018
if we declare UNIQUE KEY NOT NULL; i think we can make this work without a primary key. — arvin, Aug 16, 2018
Then is it necessary for a relational table to have primary key? Someone please confirm. — Bhagyashree Mukherje, Aug 16, 2018
@arvin

UNIQUE KEY + NOT NULL = CANDIDATE KEY

one of the candidate key choosen as PK

every candidate key is indirectly a PK

Why we have to declare a PK in relation externally ?

For prevention only... means by mistake we can insert Duplicates or NULL values in the Candidate Key

Every Table have a PK internally? ( in worst case combination of all attributes of a relation act as PK for that relation )

yes, otherwise duplicate rows are allowable in the table. — Shaik Masthan, Aug 16, 2018
here i meant implementation of a unique key with not null when we dont declare a primary key for a table as either we have to declare a key as primary key or we can manage it by declaring unique not null.

.

for a table to exist uniquely there must be a primary key so as to prevent the wastage of space to be more precise. — arvin, Aug 16, 2018
that what i am saying also.... even though you declare PK, UK + NOT NULL internally declared as PK

to prevent the wastage of space to be more precise

The space required for declaring UK and PK is equal — Shaik Masthan, Aug 16, 2018
here i have not compared memory for uk and pk...

i have told about why we need to identify records uniquely either by uk or by pk. — arvin, Aug 17, 2018

SHUBHAM SHASTRI · Answer 1 · 2018-08-16T10:09:24+0000

yes Given answer is Wrong ..it should return 0 rows..

In database the NULL is Undefined or Unknown .. so one Null can never be equal to another NULL ..

So as there is no matching .. it will simply return 0 rows...Definately it will compare NULL with NULL ...

but as they are unknown we can say nothing ...as a result compiler will simply return 0 rows

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

SQL_IN_Query

Please log in or register to add a comment.

Please log in or register to answer this question.

2 Answers

Please log in or register to add a comment.

Please log in or register to add a comment.

Related questions

17 17 Comments reply

Please log in or register to add a comment.

Please log in or register to answer this question.

2 Answers

0 reply

Please log in or register to add a comment.

1 1 comment reply

Please log in or register to add a comment.

Related questions

17 17 Comments

0

1 1 comment