Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
SELECT rowNum, l.logId,l.completed,l.next_completed,l.first_completed, isError,charge,totalTimeRange,startingDate,endingDate, CASE WHEN completed < ''',startDate,''' AND rowNum = min(rowNum) THEN time_to_sec(timediff(l.next_completed, ''',startDate,''')) / 3600 ELSE coolingHours END AS coolingHours, databaseName,i.name,l.itemId, kwDifference, cost, costT,l.details,timeInSeconds FROM tempTable3 l inner join items i ON l.logId = i.logId AND i.name LIKE ''%KW PRE%'' WHERE l.itemId = ''',myItemId,''' AND completed BETWEEN ''', startDate, ''' AND ''', endDate, '''
|understanding output of mysql version||2||50|
|MySQL left join performance||4||30|
|Have issues with Query MySQL||9||54|
|Could you point a MySQL Server query that returns the number of business hours between 02 business dates considering hollydays?||4||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!