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'

I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,

What is extent clause in table space?

1 Answers   TCS,

Are null values same as that of zero or a blank space?

0 Answers  

When sql appeared?

0 Answers  

How do you create a unique index?

0 Answers  

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

What is meant by truncate in sql?

0 Answers  

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

What is pl sql code?

0 Answers  

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

Why self join is used in sql?

0 Answers