Search Posts

Author: Roy1245

How to fetch specific row from database using mysql

how to – How to fetch specific row from database using mysql I have below mentioned table (sample): ID Value Date TT-12 call rs 2018-04-01 15:18:22 TT-12 srte er 2018-04-02 12:15:18 TT-12 efft rs 2018-04-03 13:04:08 TT-14 efft rs 2018-04-04 17:16:10 TT-14 call rs 2018-04-05 16:25:43 TT-14 srte rs 2018-04-06 21:11:47 TT-18 srte rs 2018-04-07 22:18:34 TT-18 call rs 2018-04-08 07:11:35 TT-18 call rs 2018-04-09 13:07:25 From the above table i want to fetch only […]

How to fetch data with days difference in sql

how to – How to fetch data with days difference in sql I have a table which looks like. ID Var Date1 Date2 1 A 2017-06-01 12:05:18 2017-06-25 06:08:04 2 B 2017-07-01 18:05:22 2017-07-20 18:25:04 3 C 2017-07-10 23:09:15 Null 4 D 2017-07-10 14:09:45 2017-08-01 09:45:12 5 E 2017-08-12 12:05:18 2017-09-04 07:15:04 I want to fetch those rows where difference between Date2 and Date1 is >10 days. I have tried below mentioned query but it […]

Fetched comparison data from Sql

how to – Fetched comparison data from Sql I have below mentioned data base: ID TFD1 Date CCA D-1 123 25-01-2017 AA D-2 123 24-01-2017 BA D-3 123 27-01-2017 BB D-4 456 15-01-2017 AA D-5 456 13-01-2017 BS D-6 789 11-01-2017 AA I want to fetch those ID, TFD1, Date and CCA where there are at least one value corresponding to TFD1 is AA and all the other old value corresponding to TFD1 is other […]