Monday, 12 January 2015

select Only one row from second table

SELECT * FROM tblGroup a
INNER JOIN (
SELECT * FROM tblGroupMatrix where GroupMatrixId
IN (
SELECT MIN(GroupMatrixId) OVER (PARTITION BY GroupId)
                             FROM tblGroupMatrix)) b
                             ON a.GroupId=b.GroupId


OPTIMIZED :

SELECT  *
FROM    tblGroup A
INNER JOIN tblGroupMatrix B ON A.GroupId = B.GroupId
WHERE   GroupMatrixId = ( SELECT    MIN(GroupMatrixId)
                              FROM      tblGroupMatrix
                              WHERE     GroupId = A.GroupId)

Friday, 26 December 2014

How to revel Hidden password behind stars

step 1:
Go to Browser and open desired login link where password must be filled.

step 2:
press "f12" from your key board or Right click on password Box and click "Inspect Element"




browser will look like this

Step 3:
Now find that password box and change type from "password" to "text"

Your password will look like this: