Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10490 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
What is rowtype?
What is pragma in pl sql?
How do I know if I have sql express or standard?
Can we write ddl statements in functions?
can a stored procedure call itself or recursive stored procedure? : Sql dba
How do sql triggers work?
List the various privileges that a user can grant to another user?
What does over partition by mean in sql?
Explain foreign key in sql?
How can triggers be used for the table auditing?
Explain clause in sql?
How many row comparison operators are used while working with a subquery?
What does rownum mean in sql?
Mention what plvcmt and plvrb does in pl/sql?
What does joining a thread mean?
