Partition by and Over by query to separate the single row into different columns based on the partition and over by

select st.*, rank() over(partition by st.id order by st.entr_dt, st.req_st_code) rank1from req_st st.
This is to separate a single row into different columns. This is pretty usefull.