Wednesday, August 26, 2015

How to check PF balance


How to check PF balance



  1. Open http://www.epfindia.com/site_en/KYEPFB.php
  2. Click to know PF balance in the site mentioned          
  3. Select PF Office State  
  4. Select your EPFO Office
  5. Enter Establishment code - Maximum 7 Digits
  6. Enter  Account Number - Maximum 7 Digits
  7. Enter Name (as appears in EPF Slip)
  8. Enter Mobile number
  9. Check I Agree checkbox
  10. Click on Submit
  11. You will get a message about you PF balance in your PF account

Tuesday, August 25, 2015

How to Change Address in your HDFC bank account

How to Change Address in your HDFC bank account?

So , you have shifted your home to another new home.
Do you need to change the permanent address or mailing address in you HDFC bank account?
Do you have multiple products in HDFC bank account and want to change the address of each product to permanent address.
Then here is the process. It's easy and simple now.
1. open the link  : https://leads.hdfcbank.com/applications/webforms/apply/HDFC_Bank_Address_Change/intro.aspx
2. Enter your personal details and products you want to change the address.
3. Download the filled in form
4.Take the print out of the application. Sign the application form.
5. Visit the nearest branch and submit the combined address change application form along with the address proof. In case of Permanent address  change you have to submit proof of address and proof of identity.  In case of mailing address change, write you mailing address correctly in the  combined address change form to be submitted.
List of valid address proof' accepted by bank: https://www.hdfcbank.com/htdocs/common/pdf/Documents_acceptable_as_Address_Proof.pdf
http://www.hdfcbank.com/assets/pdf/Proof_Identity_Address.pdf

6. Bank will update the new address 

Query to find the third highest salary

We can used dens_rank() function to find the rank of salaries of employees and then put in a subquery to get rank is equal to 3.   select * ...