Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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)

Answer Posted / ajit nayak

SELECT *
FROM EMP
WHERE TO_CHAR(HIREDATE,'FMDAY') = 'MONDAY';

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger price?

1046


What is rownum in sql?

1091


What are triggers and its types?

1118


explain advantages of innodb over myisam. : Sql dba

1175


Explain 3 basic parts of a trigger.

1373


How many clustered indexes can be created on a table?

1122


Can we rollback delete command?

1036


Which join is default?

1012


Explain the methods used to protect source code of pl/sql.

1070


Why use triggers in sql?

1011


Why stored procedure is faster than query?

1154


Is coalesce faster than isnull?

1017


What is composite data type in pl sql?

1168


What is trigger explain with example?

1091


What is rename in sql?

1017