Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
Answer Posted / emmanuel
Select * from emp
Where to_char(TO_DATE(hire_date),'day')='monday';
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a database event trigger?
What is trigger price?
What is data control language?
Does user triggers have entry for trigger with compilation errors?
Is sql port 1433 encrypted?
What is database sql?
Is primary key clustered or nonclustered?
What is java sql connection?
Mention what are different methods to trace the pl/sql code?
How do you create a db file?
how to select first 5 records from a table? : Sql dba
What is your daily office routine?
What are the rules to be applied to nulls whilst doing comparisons?
how to return query output in html format? : Sql dba
what is sql? : Sql dba