Himanshu Jansari

Himanshu Jansari has asked 29 questions and find answers to 82 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

REPLACE and IF in expression causes concatenation from previous row
Select all rows that have column value larger than some value
Select Count of ip and Count of DISTINCT ip in same query
Select data with conditional rules (count) from other table
MySQL WHERE with OR conditions
Using GROUP BY clause to replace dissimilar rows with single value
Execute only one exists in SQL
How to group results with conditions?
How to order by another table column
Merging some columns of two mysql tables where id = fileid