SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 MS Access
 SQL question
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Arcadia
Starting Member

1 Posts

Posted - 11/30/2013 :  17:43:18  Show Profile  Reply with Quote
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!

Edited by - Arcadia on 11/30/2013 17:43:59

jethrow
Starting Member

USA
37 Posts

Posted - 12/01/2013 :  21:03:31  Show Profile  Reply with Quote
So what do we have for tables/data?

Microsoft SQL Server Noobie
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/02/2013 :  04:49:51  Show Profile  Reply with Quote
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 function
http://www.techonthenet.com/access/functions/string/len.php

Query 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 function
http://www.techonthenet.com/access/functions/date/datediff.php

Query 4:
I want to show the exact day from a data.

Hint: Use Day function
http://www.techonthenet.com/access/functions/date/day.php


I 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 issues
In all cases post your used queries also in case of explaining the issue.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

gcreddy
Starting Member

India
1 Posts

Posted - 12/11/2013 :  03:59:41  Show Profile  Reply with Quote
http://www.gcreddy.com/2013/01/sql-interview-questions.html
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000