Select* from emp where to_char(hiredate,'dy')='mon';

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 / siva

5 Answers
10406 Views
I also Faced
E-Mail Answers

Answer Posted / siva

Select* from emp where to_char(hiredate,'dy')='mon';

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is multiple partition?

920

Can we use the cursor's to create the collection in PL/SQL?

959

How can we avoid duplicating records in a query?

922

Does sap use sql?

928

What schema means?

845

What is difference between left and right outer join?

931

What is break?

1140

How can you select unique records from a table?

992

What is view explain with example?

882

Is a table valued function object?

959

What is sql select statement?

969

How is data stored in sql?

1002

what is 'mysqlimport'? : Sql dba

974

how can you create an empty table from an existing table? : Sql dba

1077

What is a sql*loader control file?

1159