Consider the schema Person(Id, Name, Age). Write an SQL query that ?nds the 100th oldest person in the relation. A 100th oldest person is one such that there are 99 people who are strictly older. (There can be several such people who might have the same age, or there can be none.)
What will be an ideal response?
```
SELECT P.Id, P.Name
FROM Person P
WHERE
99 = (SELECT COUNT(*)
FROM Person PP
WHERE PP.Age > P.Age)
```
You might also like to view...
One of the benefits of using macros in an Access database is to:
A) increase the automation of the database by running multiple queries and reports with a single button click. B) set the correct table relationships that will help to efficiently organize the data in a database. C) automate non-routine tasks within an Access database. D) efficiently and accurately process the database from several remote locations.
The entire set of actions an organization must take to switch over to using a new program or set of programs is called ____.
A. turnover B. renovation C. translation D. conversion
The first time you add a component to a document, simply drag an instance of the component from the Components panel to the ____.
A. Stage B. Stage panel C. Dock D. Dock panel
A(n) __________________________ is a product purchasing tool that invites competing vendors to submit product and price proposals for technology products.
Fill in the blank(s) with the appropriate word(s).