sql query

Siddharth Bhardawaj asked Sep 27, 2017

757 views

2 votes

Siddharth Bhardawaj asked Sep 27, 2017

Siddharth Bhardawaj

757 views

See all

10 10 Comments

Show 7 previous comments

saxena0612

commented Sep 27, 2017

Comment on this :

0 votes

G.K.T

commented Sep 28, 2017

Yes I also think it should be zero

0 votes

Sankaranarayanan P.N

commented Oct 9, 2017

answer is 4

Refere this link for good explanation

https://stackoverflow.com/questions/28946163/all-operator-vs-any-on-an-empty-query

2 votes

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

0 votes

The ALL operator returns TRUE if all of the subquery values meet the condition.

0 columns may be returned

Rishi yadav answered Oct 9, 2017

Rishi yadav

See all

0 Please log in or register to add a comment.

Voting & Accepting an answer helps improve the community

← Previous Next →

← Previous in category Next in category →

Related questions

0 votes

1 answer

tishhaagrawal asked Dec 16, 2023

405 views

MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right? For example, in the above question - The ... the same below) Can anyone please explain whether I am approaching this right, or if I am missing something?

My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right?For example, in the...

tishhaagrawal

405 views

tishhaagrawal asked Dec 16, 2023

Databases
databases
sql
query
gate-preparation
rdbms
doubt
made-easy-test-series

+ –

2 votes

1 answer

equimanthorn asked Sep 15, 2023

340 views

Applied Roots - DBMS Practice Test 2 (SQL query order question)
A SQL query is written in its format as clauses are arranged in a specific sequence and these clauses are executed in different sequence. If we're writing a query using select, from, where, group by, having, order by, Distinct clauses. Then ... clauses are needed to be replaced while writing it's execution order. A) 1 B) 2 C) 3 D) 4

A SQL query is written in its format as clauses are arranged in a specific sequence and these clauses are executed in different sequence. If we’re writing a query using...

equimanthorn

340 views

equimanthorn asked Sep 15, 2023

Databases
databases
sql

+ –

0 votes

1 answer

rayhanrjt asked Jan 6, 2023

768 views

SQL Query
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.

Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.

rayhanrjt

768 views

rayhanrjt asked Jan 6, 2023

Databases
sql
query
databases

+ –

2 votes

1 answer

Subhrangsu asked Jun 18, 2022

447 views

Write SQL query
Write SQL query to show all employees hired on June 4,1984 (non-default format) emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)

Write SQL query to show all employees hired on June 4,1984 (non-default format)emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)

Subhrangsu

447 views

Subhrangsu asked Jun 18, 2022

Databases
sql
databases
query

+ –

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

10 10 Comments reply

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

0 reply

Please log in or register to add a comment.

Related questions

10 10 Comments

0