Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aaronis
Starting Member
1 Post |
 Posted - 2009-06-23 : 12:03:23
|
| Well I am just starting to pick up SQL on my own so I am doing lots of reading. It's tuff. Especially when no one is there to show you how it's done. Anyhow, here is what I am trying to accomplish if anyone can help. I keep failing. I figure if I see the right way then it will be clear.I am trying to write a query for all employees in MM/DD/YY format.Also, wanting to write a query to show the most recent five orders that were purchases from a cutsomer who has spent more than $25,000.If anyone can help that would be saawwwwweeeeettt. Thanks. |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-06-23 : 12:06:55
|
| Your gonna have to provide some sample data, or possibly how the table looks like with some sample data. Otherwise dont think anyone can help you with description like that. |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-23 : 12:07:25
|
| hints: (1) use convert for date format, readup books online for convert functions(2) you would also need ORDER BY and a WHERE clause to filter out > 25000.postback what you have tried and someone can help you out..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Little help please