How to write the sql statement?

Question

0.00/5 (No votes)

See more:

Hi,

i have a table as below,

TI_DEVICEID    TI_DATA                                TI_TIME
----------     -------                                -------
ST0001         DT906DT906                     7/2/2012 11:07:48 AM
ST0001         DT906DT900DT906DT900         7/2/2012 11:08:28 AM
ST0001         DT906DT900DT914               7/2/2012 11:09:28 AM

SQL

In which TI_DATA column contains the id of students in a vehicle at each time.
Then how to query the table to find the count of distinct id from TI_DATA
from 7/2/2012 11:07:48 AM  to 7/2/2012 11:09:28 AM?

thanks..

Posted 18-Jan-13 19:41pm

hasbina

Updated 18-Jan-13 19:54pm

v3

Add a Solution

2 solutions

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)

Abhinav S · Answer 1 · 2013-01-18T19:49:00

Solution 1

Try something similar to select distinct TI_DATA where TI_time between 7/2/2012 11:07:48 AM and 7/2/2012 11:09:28 AM.

Posted 18-Jan-13 19:49pm

Abhinav S

Comments

hasbina 19-Jan-13 1:57am

No.Read question

rizwan muhammed khan gouri · Answer 2 · 2013-01-18T22:59:00

Solution 2

Hello Simply You can use

Select TI_DATA, Count(TI_DATA) as Count_TI_DATA from your Table name group by(TI_DATA) 
TI_TIME between '7/2/2012' and '7/2/2012' 

it gives output
TI_DATA      Count_TI_DATA 
DT906DT906    4

Posted 18-Jan-13 22:59pm

rizwan muhammed khan gouri