Введение в СУБД MySQL


Возможные решения


mysql> select e_id, s_name -> from employee_per -> where m_status = 'Y';

или

mysql> select e_id, s_name -> from employee_per -> where s_name IS NOT NULL;

  • mysql> select e_id, s_name -> from employee_per -> where m_status = 'Y' -> ORDER BY s_name;
  • mysql> select e_id, s_name -> from employee_per -> where s_name IS NOT NULL -> ORDER BY s_name;

  • mysql> select sex, count(*) -> from employee_per -> GROUP BY sex;
  • mysql> select m_status, count(*) -> from employee_per -> GROUP BY m_status;
  • mysql> select sum(children) from employee_per;
  • mysql> select children, count(*) AS -> число from employee_per -> GROUP BY children -> ORDER BY number DESC;



  • Начало  Назад  Вперед