D-Shih

D-Shih has asked 0 questions and find answers to 51 problems.

Stats

About

Energetic, adaptable Software Engineer with over 4 years in ASP.Net. passionate about create and develop OOP，AOP program architecture， enjoy in design pattern related matters，I've created some open source project of Taiwan electronic invoice API connected framework、AwesomeProxy.Net(AOP framework).

SO Top 5 in Taiwan

D-Shih questions

D-Shih answers

Can I use one PARTITION definition for multiple window function calls?
Calculate time ago using sql
DataTable in C# - List type of column and Add method
Properly format postgres interval to HH:MM
Could not determine JSON object type for anonymous type
LEFT JOIN ON most recent date in Google BigQuery
A distributed transaction is waiting for lock
Aggregate multiple tables considering indexing with values derived from one table
Join three tables and retrieve the expected result
Postgresql wrong casting from float8 to decimal(24,8)