Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4034 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the syntax to add a record to a table?
How do I create a memory optimized filegroup?
What is the largest value that can be stored in a byte data field?
Which nosql database is best?
what is self-join? : Sql dba
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
What is sql rowcount?
Which is faster joins or subqueries?
Is it possible to sort a column using a column alias?
What is sql*plus?
what are enums used for in mysql? : Sql dba
What is data types in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
