Write a query to fetch the department -wise count of employees sorted by department’s count in ascending order. SELECT E.EmpFname, E.EmpLname, P.EmpPositionįROM EmployeeInfo E INNER JOIN EmployeePosition P ONĮ.EmpID = P.EmpID AND P.EmpPosition IN ('Manager') Write a query to fetch all employees who also hold the managerial position. SELECT * FROM EmployeeInfo WHERE Address LIKE 'DELHI(DEL)%' Write a query to fetch details of employees with the address as “DELHI(DEL)”. SELECT * FROM EmployeeInfo WHERE EmpFname NOT IN ('Sanjay','Sonia') Write a query to fetch details of all employees excluding the employees with first names, “Sanjay” and “Sonia” from the EmployeeInfo table. SELECT * FROM EmployeeInfo WHERE EmpLname LIKE '_a' To fetch details mathcing a certain value, you have to use the LIKE operator in SQL. Write a query to fetch details of employees whose EmpLname ends with an alphabet ‘A’ and contains five alphabets. SELECT * FROM EmployeeInfo ORDER BY EmpFname desc, Department asc To order the records in ascending and descnding order, you have to use the ORDER BY statement in SQL. Write a query to fetch all the records from the EmployeeInfo table ordered by EmpLname in descending order and Department in the ascending order. SELECT COUNT(*), Gender FROM EmployeeInfo WHERE DOB BETWEEN ' ' AND '' GROUP BY Gender Write a query find number of employees whose DOB is between to and are grouped according to gender SELECT CONCAT(EmpFname, ' ', EmpLname) AS 'FullName' FROM EmployeeInfo The first name and the last name must be separated with space. Write a query to retrieve the EmpFname and EmpLname in a single column as “FullName”. SELECT * FROM EmpPosition ORDER BY Salary DESC LIMIT N SELECT MID(Address, 0, LOCATE('(',Address)) FROM EmployeeInfo Write a query to fetch only the place name(string before brackets) from the Address column of EmployeeInfo table. SELECT SUBSTRING(EmpLname, 1, 4) FROM EmployeeInfo Write a query to retrieve the first four characters of EmpLname from the EmployeeInfo table. You can write a query as follows in MySQL: You can write a query as follows in SQL Server: SELECT COUNT(*) FROM EmployeeInfo WHERE Department = 'HR' Write a query to fetch the number of employees working in the department ‘HR’.
SELECT UPPER(EmpFname) AS EmpName FROM EmployeeInfo
Write a query to fetch the EmpFname from the EmployeeInfo table in upper case and use the ALIAS name as EmpName. Write a query to retrieve the EmpFname and EmpLname in a single column as “FullName”.Write a query to find the names of employees that begin with ‘S’.Write q query to find all the employees whose salary is between 50000 to 100000.Write a query to create a new table that consists of data and structure copied from the other table.Write a query to fetch only the place name(string before brackets) from the Address column of EmployeeInfo table.Write a query to retrieve the first four characters of EmpLname from the EmployeeInfo table.Write a query to fetch the number of employees working in the department ‘HR’.Write a query to fetch the EmpFname from the EmployeeInfo table in the upper case and use the ALIAS name as EmpName.Let us start by taking a look at some of the most frequently asked SQL Query interview questions, In this article on SQL Query Interview Questions, I will discuss a few queries which you must practice to become a Database Administrator and will also help you ace your interviews.įor, your better understanding, I will be considering the following tables to write queries.
#SQLITE COUNT DISTINCT LINE HOW TO#
With the humongous amount of data present, it is very important for us to understand how to use queries to retrieve the required data. SQL or Structured Query Language is a standard language for dealing with relational databases.
0 kommentar(er)
