Himanshu Jansari

Himanshu Jansari has asked 29 questions and find answers to 72 problems.

Stats

About

#SOreadyToHelp

A passionate cricketer (by heart!).
An enthusiastic programmer (by mistake!).

Himanshu Jansari questions

duplicate entry '0' for key 1 in mysql
Create duplicate form in Visual Basic 6.0
Filtered count and total count without subquery
WHERE clause with nested multiple conditions
SmtpClient sending without authentication
Nested if else in Crystal Reports
Regex to match both slash in JAVA
Right click script alter table disabled in SQL Server Management Studio

Himanshu Jansari answers

Order by inside Group_concat
How to select only year from a Date Time TSQL
How to generate this SQL query like pivot table
Mysql auto-add prefixes to fields
Multiple SQL tables added together without a JOIN
SQL Server datatype to store only time field like 09:10 etc
SQLAlchemy: Selecting one row for each distinct value of a column
MSSql (Compact) DELETE-Query with JOIN
How can I group by on a field which has NULL values?
CASE Statement in SQL WHERE clause