Database

declare @milliSecNow int
set @milliSecNow = datepart(Ms, getdate())
print milliSecNow

select
    top 100000 *
into
    #randByDate
from
    myTable
where
    recv_date between '2007-01-01' AND '2007-12-31'
--order by
--    rand(@milliSecNow)

select
    top 10 firstColumn
from
    #randByDate
order by
    rand(@milliSecNow)

drop table #randByDate

select
top 10 *
from
myTable
where
dateReceived between @startDate and @endDate
order by newid()

SELECT id, MAX(DateUpdated)
FROM MyTable
GROUP BY ID

SELECT id, DateUpdated,OtherColumns
FROM MyTable 
INNER JOIN
(
 SELECT id, MAX(DateUpdated) as MostRecentlyUpdated
 FROM MyTable
 GROUP BY ID
) MostRecentMyTable
ON MyTable.Id = MostRecentMyTable.id
AND MyTable.DateUpdated = MostRecentMyTable.MostRecentlyUpdated

<br />
select distinct id,<br />
(select top 1 t1.dateupdated from MyTable as t1 where t1.id = MyTable.id order by t1.dateupdated asc),<br />
restoftable from MyTable 

dream_liner_7e7 wrote:

i have a table of a library which contain several fields like author, publisher, isbn number etc etc. I want to write a search query in different combination if user select only author then its return result according to author, if user select multiple fields in any combination then the query must return result according to that. Can any1 help me?