Viewing 15 posts - 136 through 150 (of 186 total)
I will explain with example. I have a query "select work from entries1 WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'" and lets say it will return result
training
checkout
surfing
develop
...
I have another table...
March 5, 2013 at 3:35 am
Its just like "SELECT * FROM entries WHERE work IN (select work from entries1 WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013')". But IN matches with exact values from result column...
March 5, 2013 at 2:57 am
No,it is not mandatory to use the TOP and ORDER BY but they are required.. i can ditch order by by modifying query as "select min[a.date] from (select top 100...
March 4, 2013 at 4:22 am
I have to get min date from top 100 rows which satisfies date condition..If i do
select top 1 [date] from
WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013' order by...
March 3, 2013 at 9:50 pm
thanks for replies
We want sorting sometimes,I think we will stick to
select min[v.date]
from
(select top 100 [date]
from
WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'
order by [date] desc) V
February 28, 2013 at 11:50 pm
Anyone installed sql server 2008 R2 RTM in a Windows 8 pc?
February 28, 2013 at 12:15 am
I am installing sql server 2005 express together with my application because my application needs sql server for its working. So i choose silent mode install using command line in...
February 28, 2013 at 12:13 am
Thanks for replies
How to add Top into "select min([date]) from entries WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'" without using sub query?
February 27, 2013 at 10:08 pm
You mean "select min([date]) from entries WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'"? But we want to select minimum from top 100 rows
February 27, 2013 at 9:49 pm
What if we don't want to sort the date? Is there any easy method?
February 27, 2013 at 3:07 am
I don't think that is correct,because our query returns min(date) from top 100 rows which satisfies where condition But i don't find that in your query
February 27, 2013 at 2:33 am
sorry for that,
Actually my query contains where clause in sub query
SELECT min([date]) FROM entries WHERE [date] IN (select top(100) [date] from entries WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013' ...
February 27, 2013 at 12:53 am
Which is the best method by which i can do encryption?
February 23, 2013 at 4:32 am
Viewing 15 posts - 136 through 150 (of 186 total)