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 |
|
Arcadia
Starting Member
1 Post |
 Posted - 2013-11-30 : 17:43:18
|
Hello everyone!I hope that someone can help me out with this, i'm a starter in sql and currently i'm making some query's in Acces but there are still some sql commands that i can't figure out.I want to make the following query's Query 1: With this query i want to show the number and player that has exact 7 letters. Query 2: I want to show the numbers and date from payments that have to be paid after 1 December within 200 days. Query 3: I want to show the number and data from payments that have been paid exactly 1000 days ago. Query 4: I want to show the exact day from a data. I really hope someone can help me out with this that would really mean allot to me!  Thanks! |
|
|
jethrow
Starting Member
37 Posts |
Posted - 2013-12-01 : 21:03:31
|
| So what do we have for tables/data?Microsoft SQL Server Noobie |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-02 : 04:49:51
|
quote:
Originally posted by Arcadia
Hello everyone!I hope that someone can help me out with this, i'm a starter in sql and currently i'm making some query's in Acces but there are still some sql commands that i can't figure out.I want to make the following query's Query 1: With this query i want to show the number and player that has exact 7 letters. Hint: Use Len functionhttp://www.techonthenet.com/access/functions/string/len.phpQuery 2: I want to show the numbers and date from payments that have to be paid after 1 December within 200 days. Hint: a filter using > logic based on paiddate field Query 3: I want to show the number and data from payments that have been paid exactly 1000 days ago. Hint: use filter based on DateDiff functionhttp://www.techonthenet.com/access/functions/date/datediff.phpQuery 4: I want to show the exact day from a data. Hint: Use Day functionhttp://www.techonthenet.com/access/functions/date/day.phpI really hope someone can help me out with this that would really mean allot to me! Thanks!
Try with hints given above and post back in case of any issuesIn all cases post your used queries also in case of explaining the issue.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
gcreddy
Starting Member
1 Post |
Posted - 2013-12-11 : 03:59:41
|
| http://www.gcreddy.com/2013/01/sql-interview-questions.html |
|
|
|
|
|
|
SQL question