SQL*Plus (MOSC)

MOSC Banner

Need SQL query to display Position start date and end date

in SQL*Plus (MOSC) 10 commentsAnswered ✓

Hi All,

In our table (XX_Employee_tbl) we have data like below,

For each position we need to display min(effective_start_date) and max(end_date). Need SQL query to fetch the records.

Product Name: Oracle Database


Thanks,

Visu

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center