Search
 
SCRIPT & CODE EXAMPLE
 

SQL

How to select rows with no matching entry in another table?

SELECT Name, Gender,country, Salary, DeptName   
FROM tbl_Employee  
LEFT OUTER JOIN tbl_Department  
ON tbl_Employee.DepartmentId = tbl_Department.DeptId  
where tbl_Employee.DepartmentId is null
Comment
PREVIOUS NEXT
Code Example
Sql :: postgresql find biggest table 
Sql :: sql server 2016 reseed identity 
Sql :: mysql status 
Sql :: mysql get table size 
Sql :: how to install mysql ubuntu 
Sql :: remove mysql from centos 7 
Sql :: update sql server from another table 
Sql :: postgresql server restart 
Sql :: mysql group_concat distinct 
Sql :: list all triggers in sql server 
Sql :: return names of columns in table sql 
Sql :: sql list all databases 
Sql :: sql add column 
Sql :: mysql unix timestamp to date 
Sql :: mysql change database charset and collation 
Sql :: while loop sql 
Sql :: find mysql version linux 
Sql :: fetch first 10 rows in oracle sql developer 
Sql :: convert_tz mysql 
Sql :: reset identity column in sql server 
Sql :: how to ckeck that email is present in databse in mysqli 
Sql :: how to run mysql in git bash 
Sql :: rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client 
Sql :: append column sql 
Sql :: sql drop primary key 
Sql :: create table if not exists postgresql 
Sql :: how to add unique constraint in mysql table 
Sql :: ms sql how to see active job current run time 
Sql :: funzioni plsql 
Sql :: altering the column name in MySQL to have a default value 
ADD CONTENT
Topic
Content
Source link
Name
4+1 =