banskt

Bangalore, India

banskt.com/design

Age: 27

I am a research scholar/ graphic designer. I am pursuing my studies on statistical thermodynamics at IISc, Bangalore. I am freelance designer as well.

Apr
18
awarded Notable Question
Apr
16
revised How to prevent Facebook account block when users log in using a device placed at social gatherings?
added 3 characters in body
Apr
16
asked How to prevent Facebook account block when users log in using a device placed at social gatherings?
Mar
5
comment Android: Facebook PublishPermissions without retyping password (when using SUPPRESS_SSO)?
Thanks. I figured the bug and made relevant changes in the Facebook API. :)
Mar
5
accepted Android: Facebook PublishPermissions without retyping password (when using SUPPRESS_SSO)?
Dec
29
awarded Tumbleweed
Dec
24
awarded Autobiographer
Dec
22
awarded Teacher
Dec
22
answered What's the replacement for Session.ReauthorizeRequest?
Dec
22
revised Android: Facebook PublishPermissions without retyping password (when using SUPPRESS_SSO)?
added 1 characters in body
Dec
22
revised Android: Facebook PublishPermissions without retyping password (when using SUPPRESS_SSO)?
added 152 characters in body
Dec
22
asked Android: Facebook PublishPermissions without retyping password (when using SUPPRESS_SSO)?
Dec
22
comment How to disable Single SIgn On for facebook android app?
Thanks a lot. This was what I was looking for.
Dec
16
asked How to disable Single SIgn On for facebook android app?
Nov
26
awarded Popular Question
Oct
10
accepted How do I put a conditioned count of a joined table in a separate column of the same joined table
Oct
10
comment How do I put a conditioned count of a joined table in a separate column of the same joined table
no_of_bonus_for_company is the sum of occurrences of bonus_id for each company_id. For example, company_id 1 appears 2 times - one has a bonus_id 102, and the other is NULL - which sums up to 1. company_id 2 appears 2 times - one has a bonus_id 101, and the other is 103 - which sums to 2. company_id 3 appears once, with a bonus_id NULL so that the value of no_of_bonus_for_company is 0.
Oct
10
comment How do I put a conditioned count of a joined table in a separate column of the same joined table
Here you go - sqlfiddle.com/#!2/63dbc/1/0
Oct
10
asked How do I put a conditioned count of a joined table in a separate column of the same joined table
Oct
9
awarded Supporter
1 2 3