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

Select first_name,Last_name
from employees
where To_date('Hire_date','Day')='Monday'

Is This Answer Correct ?    6 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql procedures?

1029


What is the difference between database trigger and stored procedure?

1077


How do you copy a table in sql?

1076


What is cursor and its types?

1076


how are mysql timestamps seen to a user? : Sql dba

1139


Why stored procedure is faster than query?

1063


What is field delimiter?

1049


What's the difference between a primary key and a clustered index?

986


What is meant by user defined function?

1054


What is sql partition?

1112


what is the command used to fetch first 5 characters of the string? : Sql dba

1639


What is the difference between drop and truncate commands?

1062


what are the advantages of mysql in comparison to oracle? : Sql dba

1005


How is a process of pl/sql compiled?

1161


What are the basic techniques of indexing?

1063