MySQL中用limit查询_Mysql入门mysql查询中使用LIMIT的小例子

Drop table employee;

CREATE TABLE employee (

id int unsigned not null auto_increment primary key,

firstname varchar(20),

lastname varchar(20),

title varchar(30),

age int,

yearofservice int,

salary int,

perks int,

email varchar(60)

);

INSERT INTO employee (firstname,lastName,title,age,yearofservice,salary,perks,email) values ("John","Chen","Senior Programmer",31,3,120000,25000,"j@jbxue.com");

INSERT INTO employee (firstname,email) values ("Jan","Pillai",32,4,110000,20000,"g@yahoo.com");

INSERT INTO employee (firstname,email) values ("Ane","Pandit","Web Designer",24,90000,15000,"a@jbxue.com");

INSERT INTO employee (firstname,email) values ("Mary","Anchor",27,2,85000,"m@mail.com");

INSERT INTO employee (firstname,email) values ("Fred","King","Programmer",75000,"f@net.com");

INSERT INTO employee (firstname,"Mac",80000,16000,"j@jbxue.com");

INSERT INTO employee (firstname,email) values ("Arthur","Sam",28,14000,"e@yahoo.com");

INSERT INTO employee (firstname,email) values ("Alok","Nanda",70000,10000,"a@yahoo.com");

INSERT INTO employee (firstname,email) values ("Susan","Ra","Multimedia Programmer","h@jbxue.com");

INSERT INTO employee (firstname,email) values ("Paul","Simon",23,1,12000,"ps@jbxue.com");

INSERT INTO employee (firstname,email) values ("Edward","Parhar",30,"a@jbxue.com");

INSERT INTO employee (firstname,email) values ("Kim","Hunter","Senior Web Designer","kim@coolmail.com");

INSERT INTO employee (firstname,email) values ("Roger","Lewis","System Administrator",100000,13000,"roger@mail.com");

INSERT INTO employee (firstname,email) values ("Danny","Gibson","danny@jbxue.com");

INSERT INTO employee (firstname,email) values ("Mike","Harper","Senior Marketing Executive",36,28000,"m@jbxue.com");

INSERT INTO employee (firstname,"Sunday","Marketing Executive",5,"monica@bijbxue.com");

INSERT INTO employee (firstname,email) values ("Jack","Sim",18000,"hal@jbxue.com");

INSERT INTO employee (firstname,email) values ("Joe","Irvine",72000,"joseph@jbxue.com");

INSERT INTO employee (firstname,email) values ("Henry","Ali","Customer Service Manager",9000,"shahida@jbxue.com");

INSERT INTO employee (firstname,email) values ("Peter","Champion","Finance Manager","peter@yahoo.com");