retrieving only 3 records

[dotJoon]

data in myTable

(1) Tom
(2) Mary
(3) Jane
(4) Robert
(5) Jack

I have the above data in myTable.

Let's look at the following code and its result.

code

select id, name
from myTable
order by id

result

(1) Tom
(2) Mary 
(3) Jane
(4) Robert
(5) Jack

I like to retrieve only 3 records from myTable.
The following would-be code doesn't work correctly but it will show what I want.

would-be code

select id, name
limit 3
from myTable
order by id

target result

(1) Tom
(2) Mary 
(3) Jane

[longneck]

select id, name
from myTable
order by id
limit 3

[dotJoon]

select id, name
from myTable
order by id
limit 3

Thank you, longneck.

by the way, why is your id longneck? Are you waiting someone?


(In the culture of my country, longneck represents waiting some one, especially lover, and it develops to represent hidden beauty.)

[longneck]

no, it's derived from langanachre, which in german is roughly translated as "large landholder"

[r937]

Off Topic:

german is cool my avatar is me as a kid in my lederhosen