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
3924 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

Describe types of sql statements?

990

How do I view a table in sql?

947

What is the difference between microsoft access and sql server?

986

How to get help at the sql prompt?

1052

What is recursive join in sql?

946

What is the use of partition by in sql?

928

what is innodb? : Sql dba

1032

is mysql query is case sensitive? : Sql dba

1029

What is triggering circuit?

1015

Is there a way to automate sql execution from the command-line, batch job or shell script?

918

What is relationship? How many types of relationship are there?

1070

How do I remove all records from a table?

1023

Is sql workbench free?

929

What is the primary key?

876

What is a record in pl/sql?

1070