246 reputation
313
bio website
location Karachi, Pakistan
age 25
visits member for 2 years, 3 months
seen Nov 5 at 12:20

Web Application Developer

profile for M khalid Junaid on Stack Exchange, a network of free, community-driven Q&A sites

                 


Nov
18
awarded  Notable Question
Nov
5
awarded  Popular Question
Sep
25
awarded  Notable Question
Aug
27
comment Speed up a MySQL BETWEEN query
Can you post the EXPLAIN plan for the above query ?
Aug
26
answered MySQL - reformat a column value dependant on existing value
Aug
26
comment MySQL - reformat a column value dependant on existing value
what is the error whats not working can you elaborate it with some more brief in your question ?
Aug
24
comment Why MAX() of SUM() giving wrong output?
@babu for having clause its necessary the column you are using in having should be present in select list if you don't want e1.maxSalary in end result then i have provided another demo of sub-select thanks
Aug
24
comment Why MAX() of SUM() giving wrong output?
@babu you can use sub-select over your final query ans selected only needed columns see demo
Aug
23
answered Why MAX() of SUM() giving wrong output?
Apr
30
comment MySQL returning only 1 row, multiple entries in the database
For one row issue you can use GROUP BY employee_employeeId before order by
Apr
30
awarded  Yearling
Apr
30
accepted Get top most parent by nth child id?
Apr
30
awarded  Popular Question
Apr
3
comment How to create an Access query to find # symbol into a field?
@ypercube thanks i have updated my answer and removed fiddle for second query i have posted solution for mysql but my answer was edited by someone for access query
Apr
3
revised How to create an Access query to find # symbol into a field?
deleted 59 characters in body
Apr
3
reviewed Approve How to create an Access query to find # symbol into a field?
Apr
3
revised How to create an Access query to find # symbol into a field?
added 159 characters in body
Apr
3
answered How to create an Access query to find # symbol into a field?
Apr
2
answered Adding ID in second Table
Mar
21
comment How to merge column in mysql depending on match
@Mihai its ok to update the answer to sure it is right :) and user will have the right answer ,nothing needed