SQL : Select Query

-
Introduction:
The SELECT query/statement allows to retrieve records from one or more tables in database.

The syntax for the SELECT statement is:
SELECT [ columns] FROM [tables] WHERE [predicates];


Example #1
Let's take a look at how to select all fields from a table.
SELECT *FROM ebooks WHERE author = 'Azhar';

In our example, we've used * to signify that we wish to view all fields from the ebooks table whose author is 'Azhar'.

Example #2
You can also choose to select individual fields as opposed to all fields in the table.
For example:
SELECT name, ISBN FROM ebooks WHERE ebookid > 1000;
This select statement would return all ebooks' name and their respective ISBN values from the ebooks table where the ebookid value is greater than 1000.

Example #3
You can also use the select statement to retrieve fields from multiple tables.
SELECT category.name,ebooks.ebookid, ebooks.name FROM category,ebooks WHERE category.categoryid=ebooks.categoryid;
The result set would display category name and and ebooks lies in the category

Comments

Post a Comment

Popular posts from this blog

23 Tips to Speed Up your Windows XP Performance

-
Given below are the 23 tricks that will enhance the performance and reliability of your Windows XP OS. Best of all, most of them will cost you nothing. 1-To decrease a system's boot time and increase system performance, use the money you save by not buying defragmentation software -- the built-in Windows defragmenter works just fine -- and instead equip the computer with an Ultra-133 or Serial ATA hard drive with 8-MB cache buffer. 2- If a PC has less than 512 MB of RAM, add more memory. This is a relatively inexpensive and easy upgrade that can dramatically improve system performance. 3- Ensure that Windows XP is utilizing the NTFS file system. If you're not sure, here's how to check: First, double-click the My Computer icon, right-click on the C: Drive, then select Properties. Next, examine the File System type; if it says FAT32, then back-up any important data. Next, click Start, click Run, type CMD, and then click OK. At the prompt, type CONVERT C: /FS:NTFS and press
Read more

Potential problems in implementing Business Intelligence

-
User resistance is one big barrier to BI success; others include having to winnow through voluminous amounts of irrelevant data and poor data quality. The key to getting accurate insights from BI systems is standard data. Data is the most fundamental component of anyBI endeavour. It's the building blocks for insight. Companies have to get their data stores and data warehouses in good working order before they can begin extracting and acting on insights. If not, they'll be operating based on flawed information.
Read more

How to uninstall McAfee Security Center from your System

-
If you want to uninstall McAfee Security Center, follow these steps. 1 - Access McAfee's files in your program files folder in Explorer. Look for C:\program files\mcafee.com\agent\app. 2 - Delete all files contained in the folder. If you can’t find the McAfee application, enter "mcafee" in the Search feature on your Explorer toolbar. 3 - Go to the "Add and Remove Programs" in the Control Panel. Highlight "McAfee Security Center" and click on "Remove."
Read more