Answer / arun kumar reddy

select * from
(select emp.*,to_char(to_date(hiredate),'day') as join_day from emp)
where join_day like'mo%';

Answer / sankarapandian

select *,upper(datename(dw,gedate())) as dayofweek from
employee where upper(Convert(varchar(15),datename dw,gedate
())))='MONDAY'

Answer / mohammad murtuza ali

select firstname,lastname from hire_date where
sdate='Monday'
(or)
select firstname,lastname from hire_date where
sdate='27022010'

Answer / priya

select firstname,lastname from hire_date where to_upper
(to_char(hire_date, 'mon')) = 'MON' ;

since hire_date is of date type converting the date to
again of date type is of no use.Need to convert it to
string type and select the month.

Answer / ravindra

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

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

How do I edit a stored procedure?

0 Answers  

Define concurrency control. : Transact sql

0 Answers  

What is difference between stored function and application function?

0 Answers  

Does normalization improve performance?

0 Answers  

How many types of cursors are available in pl/sql?

0 Answers  

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

What is constant in pl sql?

0 Answers  

What is sqlexception in java?

0 Answers  

what is the purpose of update command in oracle?

7 Answers   MBT,

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers