Sql Select Statement

Question

4.00/5 (1 vote)

See more:

tblCompOff

SQL

Compofid  location    tid    compdate   userid    totdays
  1       consite     4     12-12-12      2         1
  2       consite     5     12-12-13      2         1
  3       cofsite     6     12-12-14      2         1

In my select statement i want to show like

SQL

location    userid    totdays
 consite       2        2
 cofsite       2        1

Is it possible how to proceed....,?

Posted 3-Jan-13 1:50am

tpkpradeep

Updated 3-Jan-13 1:59am

__TR__

v2

Add a Solution

3 solutions

Solution 3

SQL

select location, userid,SUM(totdays) as totdays from tablename group by location,userid

Posted 3-Jan-13 2:11am

kankeyan

Solution 2

In essence, yes it is possible, but exactly how depends on a number of factors.
Firstly there is your selection criteria - or how you pick which records you want to retrieve, and which you don't.
Secondly, it depends on how you store your information. If you want to select based on a date for example, then if you store your "compdate" field as a string it is difficult to do.

Assuming that you r fields are sensibly stored, and your selection criterisa is "on or after 13th december last year" then

SQL

SELECT location, userid, totdays FROM tblCompOff WHERE compdate >= '2012-12-13'

would do it. The WHERE clause specifies the selection criteria.

Posted 3-Jan-13 2:05am

OriginalGriff

Comments

Jibesh 3-Jan-13 8:09am

This solution doesnt fit OPs request. he wann sum of totdays for the location, I think you didnt noticed that.

OriginalGriff 3-Jan-13 8:15am

Oops! You are right I missed that :O
In my defence, I was looking at the unformatted version - but Zoltan has posted the correct version, and he was looking at the same... I'll have to blame a lack of caffiene! :laugh:

Jibesh 3-Jan-13 8:24am

You Bet. Even I thought of the same answer but when it displayed formatted it clears e.thing. :)

sariqkhan 4-Jan-13 14:55pm

http://www.codeproject.com/Questions/521783/howplustoplustransferplustheplustextplusfromplusdy
can you help me sir

sariqkhan 4-Jan-13 14:55pm

http://www.codeproject.com/Questions/521783/howplustoplustransferplustheplustextplusfromplusdy
can you help me sir

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2013-01-03T02:04:00

Solution 1

SQL

select location, userid, sum(totdays) as totdays from tablename group by location, userid

Posted 3-Jan-13 2:04am

Zoltán Zörgő

v2

Comments

URVISH_SUTHAR1 3-Jan-13 8:06am

yup above query should work as expected