samedi 19 août 2017

IF ELSE Query on MYSQL

How can i print the below structure

+--------+------------+
| Male   | Female     |
+--------+------------+
| Salman |   Meena    |
| Govinda|   Kanika   |
+--------+------------+

details from table employee

employeename        sex
Salman              male
Meena               female
Kanika              female
Govinda             male

I am using below query but output is not as expected as I need.

Query:

select (if(emp1.sex='male',emp1.employeename,'')) as Male, (if(emp1.sex='female',emp1.employeename,'')) as Female  from employee emp1;

actual output:

+--------+------------+
| Male   | Female     |
+--------+------------+
| Salman |            |
|        |   Meena    |
|        |   Kanika   |
| Govinda|            |
+--------+------------+

Aucun commentaire:

Enregistrer un commentaire