Thread: SQL question for dissimilar research.

Hi, I am a Engendering student and I am engaging the subject called SQL,and in that we have many queastion given by the SQL to excute unlikeoperation, I require to recognize about the unlike searchingquestion, as I am small bit confused in that, so any body here,recognize about SQL and their question? Require to recognizeidentical urgently, since I have an exam on this after 2 days,require few suggestion. Thanks.

I would say this is the better place you have arrive to ask, and by theway the question are too easy, and when it arrives to finding fromthe table it becomes quite interesting, since there are too manyquestion considering these, and off course they entire provides theverious outputs, I would like to suggest you that you should learn itfrom the SQL reference book, as they have identical betterexplanation on each of the question, with the instance.

Hey Friends, See, first of all as you require to find the result from the table, thequestion is too easy, ever begin such a question by the keyword take,as you have to viewed the result, thus start with choose, than nameentire the fields that you require to display in the output, like thename, rollno, date, class etc, assume that there is a table calledstudmaster and these are the fields, thus write the question like,choose name, rollno from the studmaster; this will viewed all thename and therir roll number in the output.

You can utilize many keywords in the question for searching the unlikeinstade more results, now if suppose you utilize the Distinctkeyword, it will find entire the result and viewed only the oneentries, I mean to say that the duplication would be neglected, andwhile searching the keyword ‘Where’ is apply to give thecondition, thus ever added it in the question as searching anypeculiar record.

Hey I would like to suggest you that you should try out to read fewarticles concerning these type of question, and I had also heardabout few web links like they provide their virtual editor, so fromthat we can operate the question, and we don’t have to set up thetotal software, in fact they have their own many instance, via whichyou can get the real idea about the question, not only for searching,but each type of question.

Thanks...