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
- 40648 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 are the most important ddl statements in sql?
How can you select unique records from a table?
how to dump a table to a file with 'mysqldump'? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What are different types of queries in sql?
what is the difference between delete and truncate statement in sql? : Sql dba
How can we store rows in PL/SQL using array?
What is the difference between local and global temporary table?
What is a loop in sql?
Is sqlexception checked or unchecked?
How to get unique records from a table?
How show all rows in sql?
Is inner join faster than left join?
What is the file extension for sql database?
