Although the first couple responses didn't do exactly what I was attempting, it did help understand what I was trying to accomplish.
As for the other responses... thanks QwazyWabbit, if you actually coded all that yourself, I'm quite impressed you took the time to help me that much, I appreciate it. As a side note, I actually needed 7 inputs on one line, asked once to enter only 7 digits. You said if that were the case I wouldn't need an array, but I don't see how I could accomplish this without an array?
thanks reaper and krenz.. that actually helped a lot.
as for this q2 noobie flamethread starter k_ ...if you have nothing useful to say, don't respond to my threads, so just move along, cuz from here on out you will just be ignored.
had I just asked someone to do my hw, I would have posted a problem and asked for a solution, not provided any code.
thanks again to the old q2'ers willing to help the infamous [N]auTiCa
Haven't been around the Q2 community for awhile and what better way to come back then to ask for help
Anyway, I'm having a bit of trouble with the following code.
You are to input 7 numbers then print, however if you input anything other than a number higher than 7 it says it's to high. I need user input to type in any 7 numbers from 0-9 then print all 7 on one line. If they input more than 7, it's to give an error then exit.
Select LNAME, COUNT(LNAME) FROM BORROWED GROUP BY LNAME, DEPT HAVING COUNT(LNAME)=(SELECT MAX(A.CNT) FROM (SELECT COUNT(LNAME) AS CNT FROM STUDENT GROUP BY (LNAME, DEPT)) AS A);
CREATE TABLE Student (studentid INT, firstname CHAR(20), lastname CHAR(20), grade CHAR(1), dept CHAR(25), DOB DATE, fine REAL, PRIMARY KEY(firstname);
CREATE TABLE Book (isbn INT, title CHAR(20), author CHAR(20), edition INT, bookyear DATE)
CREATE TABLE Borrowed (studentid INT, isbn INT, borrowdate DATE, due DATE)
Then I have to create 10 tuples with data for each. After that I am to retrieve data.. but will worry about that later, for now I want to know how to make up data for the tables, any ideas?
Heyy.. naut back here asking for assistance again. It's been almost a yr since I last asked for help lol.
Anways, anyone here good at SQL?
I need some help with a program and have to get this done in a couple days, so if anyone is up for helping please let me know asap and I will post what I'm having trouble with.
I highly doubt the 12-16 hour a day practicing and even so.. one can go door to door selling cookies for 16 hrs a day! be in shape and make more than he has made doing this as a career... I feel bad for these kinda guys who spend so much on a computer playing games (addicted).. whatever.
Show Posts
