Thread: SQL question for different search.

Hello, I am a student and I had pursued the subject called SQL and that we have many queries, provided by SQL to perform different functions, I want to know about the different search queries, which I am a little confused in that, so any one here know about SQL and queries? Must know very hard, because I have an exam on this after 2 days, need some advice. Thank You Very Much.

I would say this is the better place from which they have arrive to ask, on the occasion of the question are too easy and obtaining to find from the table becomes identical interesting since there are too many question for those and off course, entire of which gives unlike results, I would like to suggest to you that you should learn it from a book of reference SQL, has very better explanation on each of the question from instance.

See for how you want to search the result with the table, query, too simple, always begin with a request to select the keywords you want to display as a result, therefore, start by selecting the name of the field than all that you want to display in the output, for example, name, Date, class rollno etc, suggest that the fact that the table called studmaster and it fields, therefore, to write the query asSelect name from studmaster rollno; This will display all the names and number of the original roll therir.

Many keywords in the query can be used to find variety of quite a few results, now if you use the Distinct keyword, it will be all the search results and display only a single record, I want to say that would avoid duplication, and during the search for the keyword "Where" is used to provide status, thus always include it in the query during the search for a specific record.

Hello, I am also of the same sequence and have a very good solution for this, and I would like to give, can simply download the material from the site Web and then learn from it, as also do the same way, this way you can go also. In fact, I would say you must install SQL server, and then run these consultations on their own, then only you will get the actual functionality of consultation and all the keywords used in the query.