menu
search
Log In
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

Subjects

Network Sites

 GO Mechanical
 GO Electrical
 GO Electronics
 GO Civil
 CSE Doubts

MadeEasy Test Series: Databases - Sql

0 votes
192 views

I got why query 2 is wrong. How do I approach to understand Query 1, is there a generic approach for solving questions like these which have no tables given?

in Databases
edited by 192 views
3
First of all It is a co-related sub query . Now as you can observe , the NOT EXISTS clause is used . So the outer query will print a tuple if and only if the inner query returns nothing .

That is if at least one person who is of age less than 22 , and has rating greater than or equal to the rating of the sailor of the outer query , then the outer query shall not print anything .

So only if there is no such sailor whose age is less than 22 , and has rating greater than or equal to some sailor of the outer query , only then a sailor name shall be printed .
0

@amitqy bro if you have enough practice then you can apply what @prashant jha 1 said ,otherwise solve it by taking a small table by yourself.

Please log in or register to answer this question.

← Prev. Next →
← Prev. Qn. in Sub. Next Qn. in Sub. →

Related questions

2 votes
1 answer
1
300 views
Ace Test Series: Databases - Sql
$Emp$ $(eid: integer, ename: string, age: integer, salary :real)$ $Works$ $(eid: integer, did: integer, pct_time: integer)$ $Dept$ $(did: integer, budget: real, managerid: integer)$ $CREATE$ $VIEW$ ... The above view on Emp can be updated automatically by updating Emp. The above view cannot be created automatically. None of the above
$Emp$ $(eid: integer, ename: string, age: integer, salary :real)$ $Works$ $(eid: integer, did: integer, pct_time: integer)$ $Dept$ $(did: integer, budget: real, managerid: integer)$ $CREATE$ $VIEW$ $AvgsalaryByAge (age, AvgSalary) AS$ ... updated automatically. The above view on Emp can be updated automatically by updating Emp. The above view cannot be created automatically. None of the above
asked Dec 27, 2017 in Databases Harsh Mehta 300 views
0 votes
1 answer
2
381 views
Ace Test Series: DBMS - Correlated Sql Query
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
asked Dec 24, 2018 in Databases Shubhanshu 381 views
1 vote
0 answers
3
173 views
TEST SERIES - SQL
You executed the following SQL statements in the given order: CREATE TABLE orders (order_id NUMBER(3) PRIMARY KEY, order_date DATE, customer_idnumber(3)); INSERT INTO orders VALUES (100,'10-mar-2007',222); ALTER TABLE orders MODIFY order_date NOT NULL ... All the statements up to the ALTER TABLE statement would be committed and the outcome of UPDATE statement would be rolled back.
You executed the following SQL statements in the given order: CREATE TABLE orders (order_id NUMBER(3) PRIMARY KEY, order_date DATE, customer_idnumber(3)); INSERT INTO orders VALUES (100,'10-mar-2007',222); ALTER TABLE orders MODIFY order_date NOT NULL; UPDATE orders ... D.All the statements up to the ALTER TABLE statement would be committed and the outcome of UPDATE statement would be rolled back.
asked Dec 11, 2017 in Databases shaurya vardhan 173 views
Dark theme
Muffin by Hélio Chun
Thanks to Q2A
...