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

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

What is a balanced scorecard?

-
The balanced scorecard methodology, an outgrowth of prior measurement and management methodologies like total quality management (TQM), has existed for decades, but it was formalised in the early 1990s by Robert Kaplan and David Norton. Kaplan and Norton not only gave it a formal name but also put structure around the way organisations can measure how well they are functioning and how to predict future performance. Basically, it's a way to map and translate complex business information into something that's understandable to everyone. The methodology starts with targets defined by the organisation, followed by scorecard measures. These usually include both corporate targets and business unit targets, which are then honed into individual measures and targets. It's a very flexible approach, designed to be adapted to any organisation's needs. And virtually anything can be measured.
Read more