Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



SQL Query for different search.

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 28-05-2011
Member
 
Join Date: May 2011
Posts: 48
SQL Query for different search.
  

Hi, I am a Engendering student and I am pursuing the subject called SQL, and in that we have many queries provided by the SQL to perform different functions, I want to know about the different searching queries, as I am little bit confused in that, so any one here, knows about SQL and their queries? Need to know very urgently, because I have an exam on this after 2 days, need some advice. Thanks.

Reply With Quote
  #2  
Old 28-05-2011
Member
 
Join Date: Jul 2008
Posts: 288
Re: SQL Query for different search.

I would say this is the best place you have come to ask, and by the way the queries are too simple, and when it comes to searching from the table it becomes quite interesting, because there are too many queries regarding these, and off course they all provides the different outputs, I would like to suggest you that you should learn it from the SQL reference book, as they have very good explanation on each of the query, with the example.
Reply With Quote
  #3  
Old 28-05-2011
Member
 
Join Date: Jun 2008
Posts: 331
Re: SQL Query for different search.

See, first of all as you want to search the result from the table, the query is too simple, always begin such a query by the keyword select, as you have to display the result, thus start with select, than name all the fields that you want to display in the output, like the name, rollno, date, class etc, assume that there is a table called studmaster and these are the fields, thus write the query like, select name, rollno from the studmaster; this will display all the name and therir roll number in the output.
Reply With Quote
  #4  
Old 28-05-2011
Member
 
Join Date: Jun 2008
Posts: 370
Re: SQL Query for different search.

Hey this is too simple that you have to simply provide the name of the table and then it will retrieve the values from that table that you have mentioned in the table. Now suppose if the query is like,
SELECT Volume Identity AS 'Index Volume', Folder Name AS 'Index Folder Name'
FROM volume
WHERE Volume identity = '80'
Here, volume is the table and it will retrieve the Volume Identity and Folder Name from the table volume and will search for the condition that?s volume identity = '80'
Reply With Quote
  #5  
Old 28-05-2011
Member
 
Join Date: Jul 2008
Posts: 354
Re: SQL Query for different search.

You can use many keywords in the query for searching the different rather multiple results, now if suppose you use the Distinct keyword, it will search all the result and display only the single entries, I mean to say that the duplication would be avoided, and while searching the keyword ?Where? is used to give the condition, thus always include it in the query while searching any particular record.
Reply With Quote
  #6  
Old 28-05-2011
Member
 
Join Date: Apr 2008
Posts: 372
Re: SQL Query for different search.

Hi, I am also from the same stream, and I have a very good solution for these, and I would like to give it you, you can simply download the material from the website and then learn from it, as I also do it in the same way, this way you can practice also. In fact I would say you should install the SQL server and then run those query by your own, then only you?ll get the actual functionality of the query and all the keywords used in the query.
Reply With Quote
  #7  
Old 31-05-2011
Member
 
Join Date: Apr 2009
Posts: 484
Re: SQL Query for different search.

Hey I would like to recommend you that you should try to read some articles regarding these kind of queries, and I had also heard about some websites like they provide their virtual editor, so from that we can run the queries, and we don?t have to install the whole software, in fact they have their own many examples, through which you can get the actual idea about the queries, not only for searching, but each kind of queries. Or if you are planning to study from the reference book, then I?d say it is well and good.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "SQL Query for different search."
Thread Thread Starter Forum Replies Last Post
Noob question - phpadmin search and replace sql query - Please HELP jackpotsoftware Software Development 1 18-10-2011 04:00 PM
Google query suggestions in the search box DHR Technology & Internet 7 19-08-2009 07:20 AM
Google search results for any query displays "This site may harm your computer". itrama Networking & Security 9 01-02-2009 02:13 AM
LDAP Search Query Syntax etienne Active Directory 1 06-08-2008 07:47 PM
LDAP Search Query Error bjude Active Directory 3 17-03-2006 10:35 PM


All times are GMT +5.5. The time now is 01:24 PM.