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
- 10604 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 self join and what is the requirement of self join? : Sql dba
Define overloaded procedure?
Does execute immediate commit?
How do I save the results of sql query in a file?
What are keys in sql?
What does cursor do in sql?
What is synchronized subquery?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What are tables and fields in the database?
What does the hierarchical profiler does?
How many commands are there in sql?
Is sqlite free?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is a column in a table?
