Database

Select a.username as User, b.domainname as Domain, a.MaxDT as Date
  From 
   (
    Select username, Max(dt) as MaxDT
      From testtable
     Group By username
   ) a INNER JOIN testtable b ON a.username=b.username AND a.MaxDT = b.dt

select ID, M_ID, S_ID, min(Date)
from t
group by ID, M_ID, S_ID

select tt.userid, tt.domain, tt.date
  from ( select m.userid, max(m.domain)
           from testtable m
          group by m.userid
       ) tmp
      , testtable tt
 where tt.userid = tmp.userid
   and tt.domain = tmp.domain
;

sebastian yeok wrote:

my Date field in the database formated as 2/15/2006 11:40:46 AM .

Dim no As DateTime = New DateTime(2006, 2, 15)
Dim myConn As SqlConnection
Dim myCmd As SqlCommand = New SqlCommand
Dim myReader As SqlDataReader
Dim strSQL As String

myConn = New SqlConnection(ConfigurationSettings.AppSettings("ConnStr"))
strSQL = "SELECT Author FROM Booktbl WHERE [Date] = @date";
myCmd.CommandText = strSQL

' The parameter is added so that (1) you don't inject the value into the SQL String and
' (2) you don't have to worry about the formatting of the date as the framework will
' do that for you. Notice how @date corresponds to the @date in the strSQL above.
myCmd.Parameters.Add("@date", no)
myConn.Open()
myCmd.Connection = myConn

' Use execute scalar. Remember to check for DBValueNull in case no rows were found
' and to cast the result to what ever type Author is.
Author = myCmd.ExecuteScalar()

myReader.Close()
myConn.Close()
lblShow.Text = Subject

sebastian yeok wrote:

1) How to display the "author" using the lblShow.

sebastian yeok wrote:

in this, it retrive one record, how about retrive more records?

sebastian yeok wrote:

let say 10 records, how to display it?

sebastian yeok wrote:

how about retrive data between 2005/5/15 and 2006/5/15

SELECT Columns 
FROM MyTable 
WHERE DateColumn >= @startDate
AND DateColumn <= @endDate

sebastian yeok wrote:

myCmd.Parameters.Add("@startDate", sDate)
myCmd.Parameters.Add("@endDate", eDate)
is't correct i do like this?

sebastian yeok wrote:

10 records means, retrive 10 rows of record or more.

SELECT Column1, Column2, Column3
FROM MyTable AS mt
INNER JOIN SomeOtherTable AS sot ON mt.pk = sot.fk
INNER JOIN (SELECT fk, ColumnA, ColumnB, ColumnC
            FROM InnerTable
            WHERE ColumnD = 10) AS it ON mt.pk = it.fk
WHERE mt.Column4 IS NOT NULL
ORDER BY Column2;