i have 2 table table one 4 columns respective values a1
7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values
a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same
then 4th column values 1)Qes diff >5 then print 5 * diff
value 2)Que diff <5 print 5
- 1 Answers
- 3587 Views
- I also Faced
- E-Mail Answers
Answer Posted / anithaletchumi
select t1.name,case when abs(t1.val-t2.val) > 5 then 5 *
abs(t1.val - t2.val) else 5 end diff from tab1 t1 join tab2 t2
on t1.name=t2.name where t1.val != t2.val
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is column?
What is synchronized subquery?
What is the use of prepared statement?
What type of database is cloud sql?
What is latest version of sql?
Differentiate between pl/sql and sql?
What is a rank in sql?
What is the life of an sql statement?
Can we update views in sql?
What is memory optimized?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are stuff and replace function?
what is the use of set statement in tsql? : Transact sql
What are different joins used in sql?
Explain mutating table error.
