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
- 10703 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 the least restrictive isolation level? : Transact sql
What are different joins used in sql?
When is a declare statement required?
Can a commit statement be executed as part of a trigger?
What are few of the schema objects that are created using PL/SQL?
What is the sql query to display the current date?
Is sql injection illegal?
What is pl sql code?
How many types of cursors supported in pl/sql?
What is the difference between row level and statement level trigger?
What is the difference between functions, procedures, and packages in pl/sql?
what is isam? : Sql dba
Is hadoop a nosql?
define sql update statement ? : Sql dba
What is the purpose of normalization?
