get all employees first name department id with department id of in sql

Solutions on MaxInterview for get all employees first name department id with department id of in sql by the best coders in the world

showing results for - "get all employees first name department id with department id of in sql"

1SELECT FIRST_NAME , PHONE_NUMBER , DEPARTMENT_ID
2FROM EMPLOYEES 
3WHERE DEPARTMENT_ID IN (60,100,90,80,120)
4;

similar questions

get all employees if name ends with in sql write a query in sql to find the data of employees whose last name is 27snares 27 get first name and last name from full name string in sql write a sql query to print the name of employees having salary in each department order by department in ascending order get first 3 letter of department name in sql find out all employees with department id of 60 or 100 in sql get first n letter of department name in sql get who is hired in month in sql get who is hired in specific month in sql write a query that prints a list of employee names 28i e 3a the name attribute 29 from the employee table in alphabetical order create email address from first and last name in sql employee name starting with in sql get all employee of salary if more than in sql sql query for getting details by id write a sql query to print all department names and the name of the newest employee in that department sql hello 2c 5bfirstname 5d 5blastname 5d join first name and last name sql write a query to print every department name and the count of employees in that department

queries leading to this page

retrieve the employee id 2c first name 2c salary and department name of all employees works in the following departments 2820 2c 40 2c 70 2c 90 29 get all employees first name department id with department id of 100 in sql get all employees first name department id with department id of in sql get all employees first name department id with department id of in sql