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)
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
how to present a past time in hours, minutes and seconds? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
What are the two virtual tables available at the time of database trigger execution?
What is an invalid partition table?
Which software is used for pl sql programming?
How does sql developer connect to oracle database?
Which join condition can be specified using on clause?
What is trigger with example?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
How do you declare a user-defined exception?
How do I add a primary key to a table?
Explain spool.
Can %notfound return null after a fetch?
Why schema is used in sql?
How to pronounce postgresql?