By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

SQL Help

P: 1
I'm quite new to SQL. So pls excuse me if my problem is tooooooooooo easy for you guys.

I have a school schedule. In the table named "Classes" there is column named "StartTime". How do I write the query to find the start time for each class if they started 15mins earlier?

I need to List the subjects offered for accounting, I also need a description
for each accounting course. There should only be one column, column is seperated by a colon.

My last problem is to produce the following result set for each student:
Student ID [number] is [student] using cast function.

thanks
Oct 4 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi,

Do you have sth as query?

If yeah go in SQL view in the query builder and with copy/Paste, post it here to see what can be done!

BEst regards!
Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.