AS OUR EXAMPLE HR SCHEMA FOR GROUP WISE MAX DATE... SELECT * FROM HR.EMP

Q) How to Find Max Date from each Group? (Asked in Infosys
(INFI)Interview)

Question Posted / d ashwin

4 Answers
8440 Views
Infosys, I also Faced
E-Mail Answers

Answer Posted / d ashwin

AS OUR EXAMPLE HR SCHEMA FOR GROUP WISE MAX DATE...

SELECT * FROM HR.EMPLOYEES
WHERE HIRE_DATE IN
(SELECT MAX(HIRE_DATE) FROM HR.EMPLOYEES
GROUP BY DEPARTMENT_ID);

FOR SINGLE ROW MAX DATE...
SELECT * FROM
(
SELECT * FROM HR.EMPLOYEES
ORDER BY HIRE_DATE DESC)
WHERE ROWNUM = 1;

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain oracle data types with examples?

1030

How to insert a new row into a table in oracle?

1165

What is raw datatype?

1136

What is system tablespace?

1098

What do you mean by merge in oracle and how can we merge two tables?

1049

How to empty your oracle recycle bin?

1022

What are the execution control statements?

1065

How remove data files before opening a database?

1074

How to pass a parameter to a cursor in oracle?

1184

Explain the dml?

983

What do database buffers contain?

1032

What is merge in oracle?

1054

How to drop a stored function?

1137

What is meant by a deadlock situation?

1109

How do I limit the number of rows returned by an oracle query after ordering?

1170