Register

dbms sql

844 views

1 Answer

0 0 votes
The ans to this ques will be D. This query will return the names of 5 most expensive vegetables. For the most expensive vegetables the count of the vegetables with price greater than that particular vegetable is 0, for 2nd most expensive it is 1.. similarly for the nth most expensive vegetable it is n-1 i.e. count is less than n. So our ans is 5.
Voting & Accepting an answer helps improve the community
← Previous · dbms questions sqlNext → · dbms sql
← Previous in category · dbms questions sqlNext in category → · dbms sql
Position:
Show:

Related questions

1 1 vote
1 1 answer
122
122 views
GO Classes asked Oct 2
122 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Queries
The database contains relations $\mathrm{animals}$ and $\mathrm{visits}$, with $\mathrm{aid}$ identifying an animal.Which SQL query returns the names of animals that visi...
1 1 vote
1 1 answer
112
112 views
GO Classes asked Oct 2
112 views
GO Classes DPP | GATE CS, DA | DBMS | SQL
The $\mathrm{Employee}$ relation contains:$$\begin{array}{|c|c|c|c|} \hline \mathrm{EmployeeNo} & \mathrm{Name} & \mathrm{DateOfBirth} & \mathrm{Department} \\ \hline 000...
3 3 votes
1 1 answer
241
241 views
GO Classes asked Oct 1
241 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Queries
Relation $\mathrm{R}(\mathrm{at1},\mathrm{at2},\mathrm{at3})$ contains: $$\begin{array}{|c|c|c|} \hline \mathrm{at1} & \mathrm{at2} & \mathrm{at3} \\ \hline 12 & 15 & 510...
0 0 votes
1 1 answer
131
131 views
GO Classes asked Oct 1
131 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Queries
A concert-ticket system contains $\mathrm{Sales}$ and $\mathrm{Payment}$.Relevant rules are:a row is placed in $\mathrm{Sales}$ when a purchase application is made; if pa...