INTERVIEW QUESTIONS J2EE JAVA DETAILS

Question : Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level. Category Java Interview Questions Rating (2.8) By 9 users Added on 10/13/2004 Views 1468 Rate it! * * * * * * * * * * * * * * *

Answers: SELECT Student.name, Student.SID FROM Student, Level WHERE Student.SID = Level.SID AND Level.Level = "freshman" AND Student.Course = 3; If you have the better answer, then send it to us. We will display your answer after the approval. Rules to Post Answers in CoolInterview.com:- There should not be any Spelling Mistakes. There should not be any Gramatical Errors. Answers must not contain any bad words. Answers should not be the repeat of same answer, already approved. Answer should be complete in itself. Name :* Email Id :* Answer :* Verification Code Not readable? Load New Code   Enter the above shown code:* Inform me about updated answers to this question

	Related Questions	View Answer
	What are the disadvantages of using threads?	View Answer
	Write the Java code to declare any constant (say gravitational constant) and to get its value.	View Answer
	What do you mean by multiple inheritance in C++ ?	View Answer
	Can you write Java code for declaration of multiple inheritance in Java ?	View Answer
	What are the Object and Class classes used for?	View Answer
	What is Serialization and deserialization?	View Answer
	What interface must an object implement before it can be written to a stream as an object?	View Answer
	What is the ResourceBundle class?	View Answer
	What class allows you to read objects directly from a stream?	View Answer
	How are this() and super() used with constructors?	View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: