分類

資料庫

  • [技術]SQL IN EXISTS AND NOT EXISTS用法
    [mw_shl_code=sql,true]SELECT Emp_ID,Emp_Name,Ext,Dept_ID FROM Employees WHERE Dept_id IN (SELECT Dept_ID from Departments WHERE Mgr_id IN('890032','880017') ) ORDER BY Dept_id,Emp_Name SELECT Emp_ID,Emp_Name,Ext,Dept_ID FROM Employees E WHERE EXISTS (SELECT Dept_ ...
    01612 genie 發表於 2015-8-31 資料庫
  • Archiver|手機版|小黑屋|Ki Ki BBS

    Powered by Discuz! X5.0 © 2001-2026 Discuz! Team.

    在本版發帖返回頂部