a employee geting variable salary like jan 3000,feb 5000,mar 1000 ,apr 7000,may 500 write query to display his next salary "increse" or "decrese" as compare to previous month ,three column in the employe table empname ,salarydate,salary ?
You have a batch job which has hundreds of SQL queries in it. Earlier is was finishing in expected time. However, now it is taking twice the time. There is no cpu utilization issue due to other jobs. How would you know that which of the queries are taking more time now and why?