Generate a select query in a way that i can select 5 columns and assign a unique row.

How can i generate a select query in a way that i can select 5 columns and assign a unique row # For each of those rows. For example. I have a table my_hivetable as my_col1, my_col2, my_col3, my_col4.

The out i want from my query is: row_id, my_col1, my_col2, my_col3, my_col4
where row_id ranges from 1 till total # of rows.

Thanks in advance.

Tagged:
Sign In or Register to comment.