Write a query to find the employees from EMP table those who
have joined in Monday. (there is a column as hiredate which is
a date column i.e values are like 03-DEC-81)
- 5 Answers
- 9172 Views
- I also Faced
- E-Mail Answers
Answer Posted / masuduz zaman
SELECT * FROM EMP
WHERE (DATEPART(dw, HIREDATE) + @@DATEFIRST) % 7 = 2
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Explain 3 basic parts of a trigger.
What is sqlite format?
What are pl/sql cursors?
What is procedure function?
Name the operator which is used in the query for pattern matching?
How many types of triggers exist in pl/sql?
What is materialized view. What are different methods of refresh?
Could you please provide oca (oracle 10g) dumps for my certification ?
What is memory optimized table?
What are the different types of functions in sql?
what is the difference between delete and truncate commands? : Sql dba
How can you fetch first 5 characters of the string?
Explain the uses of control file.
What are the two virtual tables available at the time of database trigger execution?
what is a tablespace? : Sql dba
