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
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
how are mysql timestamps seen to a user? : Sql dba
how to rename an existing column in a table? : Sql dba
how to present a past time in hours, minutes and seconds? : Sql dba
What is partition by in sql?
Write a unique difference between a function and a stored procedure.
What is sql stand for?
define join and explain different type of joins? : Sql dba
What is left join in sql?
What is consistency?
how to install mysql? : Sql dba
Can you join a table to itself?
What is the use of sql trace?
Does execute immediate commit?
What do we need to check in database testing?
Why do we use triggers?