Bissoy.com
Doctors Medicines MCQs Q&A

The relation book (title, price) contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list? [select title from book as B where (select count(*) from book as T where T.price > B.price) < 5]

The relation book (title, price) contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list? [select title from book as B where (select count(*) from book as T where T.price > B.price) < 5] Correct Answer Titles of the five most expensive books

Query

The outer query selects all titles from book table. For every selected book, the subquery returns count of those books which are more expensive than the selected book. 

No two books have the same price

book B :

Title

Price

A

10

B

20

C

30

D

40

E

50

F

60

G

70

H

80

 

book T:

Title

Price

A

10

B

20

C

30

D

40

E

50

F

60

G

70

H

80

 

Query

The where clause of the outer query will be true for the 5 most expensive books.

The outer query selects all titles from the book table. For every selected book, the subquery returns count of those books which are more expensive than the selected book. The where clause of outer query will be true for 5 most expensive book. For example count (*) will be 0 for the most expensive book and count(*) will be 1 for second most expensive book.

Example

count (*) will be 0 for the most expensive book and count(*) will be 1 for the second most expensive book.

Related Questions

Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn = S.isbn;   Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 3: SELECT B.isbn, S.copies FROM Book B RIGHT OUTER JOIN Stock S ON B.isbn = S.isbn;   Query 4: SELECT B.isbn, S.copies FROM Book B FULL OUTER JOIN Stock S ON B.isbn = S.isbn;   Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?
A statement is given below in the question followed by three courses of actions numbered I, II and III. On the basis of the information given, you have to assume everything in the statement to be true, and then decide which of the following suggested courses of actions logically follow(s) for pursuing. Statement: Hindustan Unilever and Nestlé plan to selectively increase prices of their products to take into account higher crude oil and petrol costs, the rupee’s depreciation against the dollar and more expensive commodities such as wheat. If crude remains where it is and if the rupee has depreciated, of course, there are headwinds as far as costs are concerned. I. Nestlé India’s logistics providers are looking to renegotiate rates after record-high petrol and diesel prices. Nestlé declined to comment on when and by how much prices would increase.  II. Nestlé commented that HUL had dropped prices in November after the Goods & Services Tax was introduced last year and an increase in prices now would likely not hurt consumers.  III. Petrol prices have crossed Rs 90 a litre in Mumbai on increasing global prices of crude oil, of which India is a net importer, further impacted by the falling rupee. Crude derivatives, which are key inputs for FMCG companies, and petroleum derivatives used in packaging material including bottles and tubes, have also become more expensive.
A shopkeeper has 11 books of same cost price. He sells the first book at certain price, then he sells second book at a price which is Rs. 1 less than the selling price of first book and then he sells third book at a price which is Rs. 1, less than the selling price of second book. Following this pattern, he sold all 11 books. If he sells sixth book at its cost price. Find the over-all percent profit or loss on selling all 11 books = ?
Seven different coloured books are kept one after the other. i. The RED book is just on the top of the ORANGE book. ii. The BLUE book is between the GREEN and the YELLOW books. iii. The VIOLET book is between the GREEN and the BLACK books. iv. There are as many books between the GREEN and the RED books as there are between the BLACK and the BLUE books. If the YELLOW book is on the top, which book is exactly in the middle?
Anya, Banya, Dinya and Vinya brought a story book for their classmate. The book is with someone among them. They all know who has the book and each one makes a statement about this. Select the person with the book if only one of them is making a false statement. statements : Anya: I don’t have the book and Dinya also doesn’t have the book. Banya : I don’t have the book and Anya also doesn’t have the book. Dinya : I don’t have the book and Banya also doesn’t have the book. Vinya : I don’t have the book and Anya also doesn’t have the book.
In the following passage some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of the four alternatives. Books are our ______ friends. They are our guides. We can learn everything from them. The books contain all the great ______ of the world's leaders and we can learn them by reading the books. The books help us find ______ to our questions. The books never fail us. We should read as ______ books as we can. But all books are not good. So we should ______ only good books. So we should ______ only good books and read them.
In the following passage some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of the four alternatives. Books are our ______ friends. They are our guides. We can learn everything from them. The books contain all the great ______ of the world's leaders and we can learn them by reading the books. The books help us find ______ to our questions. The books never fail us. We should read as ______ books as we can. But all books are not good. So we should ______ only good books. ______ books as we can.
In the following passage some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of the four alternatives. Books are our ______ friends. They are our guides. We can learn everything from them. The books contain all the great ______ of the world's leaders and we can learn them by reading the books. The books help us find ______ to our questions. The books never fail us. We should read as ______ books as we can. But all books are not good. So we should ______ only good books. The books help us find ______ to
In the following passage some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of the four alternatives. Books are our ______ friends. They are our guides. We can learn everything from them. The books contain all the great ______ of the world's leaders and we can learn them by reading the books. The books help us find ______ to our questions. The books never fail us. We should read as ______ books as we can. But all books are not good. So we should ______ only good books. Books are our ______ friends.
Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R: All attributes used in the GROUP BY clause must appear in the SELECT clause S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause