Write an SQL query to fetch the employees whose name begins with any two characters, followed by a text “hn” and ending with any sequence of characters. Write an SQL query to fetch all the EmpIds which are present in either of the tables – ‘EmployeeDetails’ and ‘EmployeeSalary’. Table - EmployeeDetailsEmpld FullNameManagerldDateOfJoiningCity121John Snow32101/31/2014Toronto321Walter White98601/30/2015California421Kuldeep Rana87627/11/2016New DelhiTable - EmployeeSalaryEmpldProjectSalaryVariable121P18000500321P2100001000421P112000

Answered: Write an SQL query to fetch the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Write an SQL query to fetch the employees whose name begins with any two characters, followed by a text “hn” and ending with any sequence of characters.

Write an SQL query to fetch all the EmpIds which are present in either of the tables – ‘EmployeeDetails’ and ‘EmployeeSalary’.

Table - EmployeeDetails
Empld FullName
Managerld
DateOfJoining
City
121
John Snow
321
01/31/2014
Toronto
321
Walter White
986
01/30/2015
California
421
Kuldeep Rana
876
27/11/2016
New Delhi
Table - EmployeeSalary
Empld
Project
Salary
Variable
121
P1
8000
500
321
P2
10000
1000
421
P1
12000

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions