SQL query to get column of the next row to be of column of a row and the second row of the column to the next row
Naveen Chebrolu
I want to write a SQL query to get column of the next row to be of column of a row. the test example is as follows
I want to get SQL query to get result as follow:
Vamsi Prabhala
You can do this with LEAD provided the version you are on supports it.
select customer,orderdate,item,
lead(orderdate,1) over(partition by customer order by date) as second_date,
lead(item,1) over(partition by customer order by date) as second_item,
lead(orderdate,2) over(partition by customer order by date) as third_date,
lead(item,2) over(partition by customer order by date) as third_item
from tbl
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Import Excel Data without Inserting Into Table
- Next: Dynamic webtable rows storing, searching and handling with java webdriver
Related
Related Related
- 1
sql query to get column of the next row to be of column of a row
- 2
How to get next row column by javascript or jquery
- 3
Subtract column with the next column in a different row
- 4
sql query for grouping column into row
- 5
Seperate row in column with SQL query
- 6
Getting a Column on the next Row on excel with Macro
- 7
find next row in DataFrame based on column values
- 8
Create new column based on next row
- 9
Why is Bootstrap moving the last column to the next row?
- 10
Python - How to Compare a column value of one row with value in next row
- 11
compare special column of each row with next row using bash
- 12
adding a value to a column from data in next row sql
- 13
VBA script to add formula to a column if next column has data in that row
- 14
AWK replace null column with the column value of next row
- 15
Merge rows based on column value and value different column in next row
- 16
Get a value of a row in a column
- 17
SQL Pivot row to column?
- 18
print second column in transposed row
- 19
SQL Query to Transpose Column Counts to Row Counts
- 20
Multiple CSV Column to Row SQL Query
- 21
How to pivot a column into a row for sql query
- 22
SQL: Select a row from a table with an additional column containing the next value of the column
- 23
sql query get multiple values from same column for one row
- 24
SQL query to get computed values from the same column in one row
- 25
Get same column in same row two times in SQL query
- 26
Sql query to get 1 from each column row wise
- 27
TSQL: How to Copy value from one column from the previous row into the next row in a different column
- 28
How to use previous row's column's value for calculating the next row's column's value
- 29
How to replace a column in a row with the next row having specific condition on that column in R?
Comments