Re: Query Question

Hi!

If i'm trying to filter by Date and Time which is 2 seperate data field
distintively, how's the sql query be like? What i wanted to achieve here is
every rows will have a distinct date and time. Any idea? Thks!

"Hari Prasad" wrote:

> Hi,
>
> see DISTINCT / GROUP BY CLAUSE in books online
>
> Thanks
> Hari
> SQL Server MVP
>
> "David" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:3FFA38D5-ABE8-45C3-B1DB-CB678852B45E@xxxxxxxxxxxxxxxx
> > Hi! what command should i include in the SELECT query statement so that i
> > can
> > filter away the duplicate record(see only unique row)...eg by time. Thks!
>
>
>
.

Relevant Pages

  • Re: In VBA how do I link the fields of a form to an on-the-fly SQL
    ... Filter and FilterOn properties. ... Assuming that the Constellation, StarName, ... Now I create a SQL query for just those stars in Orion. ... Dim db as Database, rst as Recordset, strSQL as String ...
    (microsoft.public.access.queries)
  • Re: A very basic search form in access
    ... > gets inserted into a sql query and the results of the query gets ... From the PopUp menu I click on "Filter By Form" ... In the Payee TextBox I enter "Like Sh*" without the quotation marks. ... From the PopUp menu I click "Apply Filter/Sort". ...
    (comp.databases.ms-access)
  • Re: select ... count ... inner join statement
    ... > It would help if we knew all the possible values for statusm but given ... I have just added the line you proposed to my SQL query, ... With the filter you propose, instances that return zero are ommited. ... I've never seen such a beast. ...
    (microsoft.public.inetserver.asp.db)
  • RE: Applying Filter
    ... If you want to apply the filter to DB query, sql query is like ... If you get whole data into a datatable then apply the filter, ... > tried the Data Form Wizard in Visual Studio, ... > Catch eLoadMerge As System.Exception ...
    (microsoft.public.dotnet.framework.adonet)
  • Query Question
    ... what command should i include in the SELECT query statement so that i can ... filter away the duplicate record...eg by time. ... Thks! ...
    (microsoft.public.sqlserver.mseq)