select t1.name,case when abs(t1.val-t2.val)

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

Question Posted / anithaletchumi

1 Answers
4025 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

Please Help Members By Posting Answers For Below Questions

How do I save a sql query?

1018

Does truncate table reset auto increment?

999

what is collation? : Sql dba

1158

Enlist the data types that can be used in pl/sql?

1073

what is data control language? : Sql dba

1030

What is schema in sql?

955

How does one use sql*loader to load images, sound clips and documents? : aql loader

1188

What is plpgsql language?

1067

What is normalization in a database?

1161

What do you understand by case manipulation functions?

1035

What are all the different normalization?

1044

What is a data definition language?

1139

What is foreign key and example?

942

What are the differences between implicit and explicit cursors?

1071

What is difference between primary and secondary key?

1030