How to answer a query from my boss?
We cannot give you a sample letter, because we do not know what the query was all about. However, as a general rule, always answer with the truth.
PLS HELP! @_@ I can't answer this one. (Query on the option box)?
Guys, help, this is my homework too much for for a sixth grader. Pls, help, ASAP. What are the factors of: x²-15x+56 Pls, show the solution if possible, pls explain your answer too. PLS. It will be a big help for me. Thank you.
SQL Query help....?
SELECT T_patient.name, Max(T_appointment.Date) AS LastDate FROM T_patient INNER JOIN T_appointment ON T_patient.name = T_appointment.name GROUP BY T_patient.name; This is a basic join of two tables using the patients name in a one to many relationship. You will have to use your tables primary and foreign keys whatever they may be.(SSN, recordID ect). for example: WHERE T_patient.(primary key like SSN) = T_appointment.(foreign key like SSN) Also you cannot use the * to return all fields, rather you will have to add each field name from the patients record table. I have only added a single field here for clarity. This SQL statement will return a single record based upon the matching of the max date value in the T_appointment table.
Urgent, Trapezium rule HELP, 10pts for 1st to answer all my queries?
I'm assuming you mean the trapezoid rule. The equation for the trapezoid rule is h*(.5*y0 + y1 + y2 + ...+ (.5)*yn) If you're going from 0 to 3, and you have 4 ordinates, then your h = (b-a)/(#strips) = (3-1)/3 = 1 To find the y1, y2, y3 etc, you you plug numbers into your sqrt(2^x) equation, from 0 to 3, at an interval of your h value (which is 1) so y0 = sqrt(2^0) = 1 and y1 = sqrt(2^1) = sqrt(2) and y2 = sqrt(2^2) = 2 and y3 = sqrt(2^3) = sqrt(8) now using the equation for the trap rule, you have 1*(.5*1 + sqrt(2) + 2 + .5*sqrt(8)) = 5.33
Can someone help me with this SQL query?
The schema for the LibraryDB database is given below. borrow(transactionID, personID*, borrowdate, duedate, returndate) author(authorID, firstname, middlename, lastname) book_copy(bookID, bookdescID*) book(bookdescID, title, subtitle, edition, voltitle, volnumber, language, place, year, isbn, dewey, subjectID*) borrow_copy(transactionID*, bookID*) person(personID, firstname, middlename, lastname, address, city, postcode, phonenumber, emailaddress, studentno, idcardno) publisher(publisherID, publisherfullname) written_by(bookdescID*, authorID*, role) published_by(bookdescID*, publisherID*, role) subject(subjectID, subjecttype) The primary keys are underlined. The foreign keys are denoted by asterisks (*). Question I need is to write query language Display the firstname and lastname of the people who returned books late more than once.