Register

Write SQL query

• edited by
838 views
2 2 votes
Write SQL query to show all employees hired on June 4,1984 (non-default format)

emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)

1 Answer

Voting & Accepting an answer helps improve the community
← Previous · Hi. My gate score is...Next → · GO Classes CS Test S...
← Previous in category · Self - DoubtNext in category → · appsc-2012-DL CA
Position:
Show:

Related questions

1 1 vote
1 answers 1 answer
1.2k
1.2k views
tishhaagrawal asked Dec 16, 2023
1,177 views
MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right?For example, in the...
0 0 votes
1 1 answer
1.8k
1.8k views
rayhanrjt asked Jan 6, 2023
1,794 views
SQL Query
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
1 1 vote
1 1 answer
2.5k
2.5k views
Shubhanshu asked Dec 24, 2018
2,533 views
Ace Test Series: DBMS - Correlated Sql Query
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
0 0 votes
0 0 answers
1.2k
1.2k views
Ashwani Yadav asked Dec 20, 2018
1,162 views
SQL Query
Suppose there are two tuples in Animals relation with different IDs but of same type and in Adoption table there is a tuple with an ID that matches with the ID of first ...