Nita Reddy (1/11/2017)
from the below table I need the Last_data and last_data from 6 month. with different DB_nameso my output would look like :
DB_name backup_start Backup_finish
Stock_any 8/1/2016 8/1/2016
Stock_any 1/1/2017 1/1/2017
Bond 8/1/2016 8/1/2016
Bond 1/1/2017 1/1/2017
DB namebackup StartBackup Finish
Stock_Any5/1/20165/1/2016
Stock_Any6/1/20166/1/2016
Stock_Any7/1/20167/1/2016
Stock_Any8/1/20168/1/2016
Stock_Any9/1/20169/1/2016
Stock_Any10/1/201610/1/2016
Stock_Any11/1/201611/1/2016
Stock_Any12/1/201612/1/2016
Stock_Any1/1/20171/1/2017
bond5/1/20165/1/2016
bond6/1/20166/1/2016
bond7/1/20167/1/2016
bond8/1/20168/1/2016
bond9/1/20169/1/2016
bond10/1/201610/1/2016
bond11/1/201611/1/2016
bond12/1/201612/1/2016
bond1/1/20171/1/2017
Please present your data in consumable format – you've been here long enough to know how to do this.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.