Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 41169 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / sankarapandian
select *,upper(datename(dw,gedate())) as dayofweek from
employee where upper(Convert(varchar(15),datename dw,gedate
())))='MONDAY'
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is pl sql quora?
How many indexes can be created on a table in sql?
Why is sql better than hql?
what are the performance and scalability characteristics of mysql? : Sql dba
When is the explicit cursor used ?
How do I sort a table in sql?
When is the update_statistics command used?
What does where 1/2 mean in sql?
what is the difference between sql and t-sql? : Transact sql
What is pl sql in dbms?
how to use regular expression in pattern match conditions? : Sql dba
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Why do we use triggers?
What are the triggers associated with image items?
Is it possible to sort a column using a column alias?
