StackOverflow question #42314159, MySQL

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

CREATE TABLE IF NOT EXISTS ds_tbl_event_question (created_date DATETIME, field_type VARCHAR(255), answer TEXT);
    
    DELETE FROM ds_tbl_event_question;
    
    INSERT INTO ds_tbl_event_question (created_date, field_type, answer)
    VALUES ('2016-09-18 09:15:51', 'full_name', 'demo user');
    INSERT INTO ds_tbl_event_question (created_date, field_type, answer)
    VALUES ('2016-09-18 09:15:51', 'email', 'demo@test.com');
    INSERT INTO ds_tbl_event_question (created_date, field_type, answer)
    VALUES ('2016-09-18 15:41:45', 'full_name', 'sagar panchal');
    INSERT INTO ds_tbl_event_question (created_date, field_type, answer)
    VALUES ('2016-09-18 15:41:45', 'email', 'sagar@gmail.com');
    
    SELECT full_names.answer AS full_name, emails.answer AS email FROM
    (SELECT created_date
     FROM ds_tbl_event_question
     GROUP BY created_date) created_dates
    JOIN 
    (SELECT created_date, answer
     FROM ds_tbl_event_question
     WHERE field_type = 'full_name') full_names
    ON full_names.created_date = created_dates.created_date
    JOIN 
    (SELECT created_date, answer
     FROM ds_tbl_event_question
     WHERE field_type = 'email') emails
    ON emails.created_date = created_dates.created_date


Absolute service time: 0,25 sec, absolute service time: 0,25 sec