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
- 10675 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
How do I find duplicates in sql?
Do we need to rebuild index after truncate?
Why is %isopen always false for an implicit cursor?
What is difference between nchar and nvarchar?
What is pragma in pl sql?
what is column? : Sql dba
Name three sql operations that perform a sort.
What is the difference between sum and count in sql?
Explain the components of sql?
What is forward declaration in pl sql?
What does the argument [or replace] do?
What are the main features of cursor?
How to Declare Fixed Length String Value In PL SQL
What is the usage of nvl function?
What is a database trigger?
