It is the most asked question in interview. Interviewer want your concept of limit and query should be crystal clear. We have explained from creation of table to display table data. At last we have given a simple query to execute second highest salary.

Table can be created using create statement. We can create table using following statement like

create table employee (id int(11) not null auto_increment primary key, name varchar(255));

But sometime we need to create a new table based on the content of old table. We use following statement to create new tables based on old tables.