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)
```
Computer Science & Information Technology
You might also like to view...
Click ________ in the Sort & Filter group on the Data tab to removed any existing filters that have been applied to a data set on the Excel worksheet
A) Delete B) Clear C) Remove D) Cancel
Computer Science & Information Technology
A system administrator is asked to set up several physical file servers that have recently crashed due to a power failure. Which of the following documents should the administrator refer to in order to complete this task?
A. Server configuration documentation B. Network diagram C. Asset management documentation D. Dataflow diagram
Computer Science & Information Technology