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...
Discuss how cost control can be accomplished using contracts.
What will be an ideal response?
Computer Science & Information Technology
What is wrong with this function?
```void Multiply( int x, int y ) { int z; z = x * y; return z; }``` A. You can’t have 2 input arguments. B. Multiply doesn’t know what z is. C. The return type is void. D. There is nothing wrong with it.
Computer Science & Information Technology
Which of the following can be used to provide wireless network segmentation?
A. SSID B. MAC filtering C. WPA2 D. SAM
Computer Science & Information Technology
The main elements of the To-Do List window are the ____.
A. Notes Pane B. Preview pane C. Navigation Pane D. To-Do List pane
Computer Science & Information Technology