You are not logged in.

#1 2015-09-18 06:18:22

husnain
User RankUser RankUser RankUser RankUser RankUser Rank
Administrator
From: Chichawatni,Pakistan
Registered: 2014-10-03
Posts: 8,129
Website

SQL Tuples:

Database Quizzes SQL

Question:
Find all the tuples having temperature greater than 'Paris'.

Option A):
SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')
Option B):
SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')
Option C):
ECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris')

Correct Answer is Option A):
SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')


You cannot discover the new oceans unless you have the courage to lose the sight of the shore.

2015-09-18 06:18:22

Advertisement
Ads By Google

Re: SQL Tuples:



Board footer