select * from tbl_employees where DATENAME(DW,hiredate)='Monday'

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)

Question Posted / pramod

5 Answers
10835 Views
I also Faced
E-Mail Answers

Answer Posted / pramod

select *
from tbl_employees
where DATENAME(DW,hiredate)='Monday' order by hiredate

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to show all tables with 'mysql'? : Sql dba

1159

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1896

Mention what are different methods to trace the pl/sql code?

1296

Is pl sql a programming language?

1045

What is a primary key example?

1003

What is %rowtype in pl sql?

1032

What is a sql*loader control file?

1344

What is restrict in sql?

1179

What mean sql?

1054

Is there a 64 bit version of ssms?

1000

what are the authentication modes in sql server? : Sql dba

1121

What is java sql driver?

1186

Explain character-manipulation functions?

1176

What is a sql statement?

1019

Which join is default?

1016