find out all employees with department id of 60 or 100 in sql

Solutions on MaxInterview for find out all employees with department id of 60 or 100 in sql by the best coders in the world

Search
showing results for - "find out all employees with department id of 60 or 100 in sql"
Tiphaine
15 Aug 2016
1SELECT * FROM EMPLOYEES 
2WHERE DEPARTMENT_ID = 60 OR DEPARTMENT_ID = 100 ;
similar questions
write a sql query to print the name of employees having salary in each department order by department in ascending orderget all employees first name department id with department id of in sqlsql use with to get value counts and percentagesget who is hired in specific month in sqlget records in sql according to month name and countsql only show where count is great than 1get all employees first name department id with department id of 100 in sqlcount number of entries including 0s sqlnumber 2810 2 29 in sql meansgiven an id number calculate age in mysqlsql query to find percentage of null values in a tablewrite a query in sql to find the data of employees whose last name is 27snares 27find above average salary earner in sqlhow to find total working hour in sqlselect all records where the customerid column has the value 32 ms sql row number over partitionwrite a sql query to print all department names and the name of the newest employee in that departmentcount number of entires by months sqlget all employees if name ends with in sqlget all employee of salary if more than in sqlhow to put 0 or 000 depending idcustomer length in sql servercalculate percentage in sqlsecond last highest id in sqlwrite a query to print every department name and the count of employees in that department
queries leading to this page
get all employees first name department id with department id of 100 in sqlwrite an sql query that returns a table comprising all the departments in the table department that hire at least one employeefind out all employees with department id of 60 or 100 in sqlwrite a sql query that returns a table compromising of employees dept idcross tabulation values to display the total salary for it progwrite a sql query that returns a table compromising of employeeswrite a sql query that returns a table comprising all the departments 28dept id 29find out all employees with department id of 60 or 100 in sql