Marek at 15:23, 17 July 2012

2012-07-17T15:23:54Z

Marek at 15:23, 17 July 2012

2012-07-17T15:23:26Z

Marek at 15:23, 17 July 2012

2012-07-17T15:23:10Z

Marek: Created page with "How can I select the oldest person in the table PERSON by birthday?

schema:scott

I have a table `PERSON(personID, name..."`

2012-07-17T15:22:52Z Created page with "How can I select the oldest person in the table PERSON by birthday? <div class='ht'> <div class=params>schema:scott</div> <div> I have a table <tt>PERSON(<u>personID</u>, name..." New page How can I select the oldest person in the table PERSON by birthday? <div class='ht'> <div class=params>schema:scott</div> <div> I have a table <tt>PERSON(<u>personID</u>, name, sex, birthday, placeOfBirth)</tt> Now I would like to SELECT the oldest person in the table by birthday. '''Answer:''' Use a nested query to find the earliest birthday. </div> <source lang=sql class='tidy'></source> <source lang=sql class='setup'></source> <source lang='sql' class='def e-sqlserver'> -- Set up the problem DROP TABLE people; CREATE TABLE people(personId INTEGER PRIMARY KEY, name VARCHAR(20), sex CHAR(1), birthday DATE, placOfBirth VARCHAR(20)); INSERT INTO people VALUES (1,'Oliver','M','25 May 1985','Bedford'); INSERT INTO people VALUES (2,'Andrew','M','20 May 1962','Hong Kong'); -- Here is the answer SELECT * FROM people WHERE birthday = (SELECT MIN(birthday) FROM people) </source> <source lang='sql' class='def e-access'> -- Set up the problem DROP TABLE people; CREATE TABLE people(personId INTEGER PRIMARY KEY, name VARCHAR(20), sex CHAR(1), birthday DATE, placOfBirth VARCHAR(20)); INSERT INTO people VALUES (1,'Oliver','M','25 May 1985','Bedford'); INSERT INTO people VALUES (2,'Andrew','M','20 May 1962','Hong Kong'); -- Here is the answer SELECT * FROM people WHERE birthday = (SELECT MIN(birthday) FROM people) </source> <source lang='sql' class='def e-postgres'> -- Set up the problem DROP TABLE people; CREATE TABLE people(personId INTEGER PRIMARY KEY, name VARCHAR(20), sex CHAR(1), birthday DATE, placOfBirth VARCHAR(20)); INSERT INTO people VALUES (1,'Oliver','M','25 May 1985','Bedford'); INSERT INTO people VALUES (2,'Andrew','M','20 May 1962','Hong Kong'); -- Here is the answer SELECT * FROM people WHERE birthday = (SELECT MIN(birthday) FROM people) </source> <source lang='sql' class='def e-oracle'> -- Set up the problem DROP TABLE people; CREATE TABLE people(personId INTEGER PRIMARY KEY, name VARCHAR(20), sex CHAR(1), birthday DATE, placOfBirth VARCHAR(20)); INSERT INTO people VALUES (1,'Oliver','M','25 May 1985','Bedford'); INSERT INTO people VALUES (2,'Andrew','M','20 May 1962','Hong Kong'); -- Here is the answer SELECT * FROM people WHERE birthday = (SELECT MIN(birthday) FROM people) </source> <source lang='sql' class='def e-mysql'> -- Set up the table DROP TABLE people; CREATE TABLE people(personId INTEGER PRIMARY KEY, name VARCHAR(20), sex CHAR(1), birthday DATE, placOfBirth VARCHAR(20)); INSERT INTO people VALUES (1,'Oliver','M','1985-05-25','Bedford'); INSERT INTO people VALUES (2,'Andrew','M','1962-05-20','Hong Kong'); --Here is the answer SELECT * FROM people ORDER BY birthday ASC LIMIT 1 </source> <source lang='sql' class='def'> -- Set up the problem DROP TABLE people; CREATE TABLE people(personId INTEGER PRIMARY KEY, name VARCHAR(20), sex CHAR(1), birthday DATE, placOfBirth VARCHAR(20)); INSERT INTO people VALUES (1,'Oliver','M','25 May 1985','Bedford'); INSERT INTO people VALUES (2,'Andrew','M','20 May 1962','Hong Kong'); -- Here is the answer SELECT * FROM people WHERE birthday = (SELECT MIN(birthday) FROM people) </source> <div class="ecomm e-db2" style="display: none"> We can order by birthday and select the first one only. If there are two or more oldest people then only one of them will be returned. </div> </div> {{DATE and TIME ref}}

@@ Line 1: / Line 1: @@
 How can I select the oldest person in the table PERSON by birthday?
 <div class='ht'>
-<div class=params>schema:scott</div>
+<div class=params>schema:gisq</div>
 <div>
 I have a table

@@ Line 4: / Line 4: @@
 <div>
 I have a table
 <tt>PERSON(<u>personID</u>,
 name,

Select the oldest person - Revision history

Marek at 15:23, 17 July 2012

Marek at 15:23, 17 July 2012

Marek at 15:23, 17 July 2012

Marek: Created page with "How can I select the oldest person in the table PERSON by birthday? schema:scott I have a table PERSON(personID, name..."

Marek: Created page with "How can I select the oldest person in the table PERSON by birthday?

schema:scott

I have a table `PERSON(personID, name..."`