How to use case here
ManiMuthuPandi
I need to create a SQL query to generate the below output from DB.
I am searching a condition like this
When week_val is 1 then hour_val should come from week_val 2 row. Otherwise hour_val comes from same row.
Jaydip Jadhav
You may need subquery with CASE Statment
SELECT CASE WHEN week_val =1 THEN (SELECT TOP 1 hour_val FROM TABLE NAME WHERE week_val <> 1)
ELSE hour_val
END
FROM TableName
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: How to set Rollback in case of Error in Talend?
- Next: Retrieving data from Firebase Android Studio
Related
Related Related
- 1
How to use lists properly here?
- 2
how to use DISTINCT here in my query CODEIGNITER
- 3
How to use python -c "code here" with newlines?
- 4
How to use <h:commandButton action="#{method here}" />?
- 5
How to use a here document in a loop?
- 6
How to use bind correctly here?
- 7
How to use struct in this case
- 8
How to use a functional in this case?
- 9
How to use Case in SQL?
- 10
How use case with findwindow
- 11
How to use mocking in this case?
- 12
How to use decltype in this case
- 13
How to use lastInsertId in this case?
- 14
how to use DISTINCT here in my query CODEIGNITER
- 15
sql how to use case?
- 16
How to use a here document in a loop?
- 17
How to use CASE in MySQL?
- 18
How to use bind correctly here?
- 19
How to use case with in operator
- 20
How to use group by query here
- 21
How to use reduce in this case?
- 22
How to use the start command properly here?
- 23
How to use mocking in this case?
- 24
how to use exit inside here doc
- 25
How to use decltype in this case
- 26
How to use instanceof operator of java here?
- 27
How do I use a forloop correctly here?
- 28
How to use join here
- 29
How to use monad in this case?
Comments