Using the WHERE clause with the SQL SELECT Statement

Author: databasedev.co.uk | Published: 27th Jan 2006 | Visited: 323 times | Add Comment
Filed in: MS Access

Using the WHERE clause with the SQL SELECT Statement: You can create more powerful SQL SELECT queries by using the WHERE clause to choose to display only specific rows contained in the database table. The WHERE clause is used to filter the data that the SELECT statement would return in the resultset. We use the WHERE clause to specify a value to identify one or more rows in the database table. We will use the following syntax to execute an SQL SELECT query with a WHERE clause.......

Read Article

Sponsored Links

• Select Which Panel Displays AutoHint in Delphi's TStatusBar in Delphi TIPS :: The TStatusBar Delphi control displays a row of panels, usually aligned at the bottom of a form. When AutoHint is true, the status bar automaticall ...

• Using the SelectDirectory Delphi routine - to Select a Directory/Folder in Delphi TIPS :: You can display a dialog to the user to allow directory/folder selection without using a TOpenDialog component. First, add FileCtrl unit to the uses clause o ...

• CodeSnip: How to Select the Records from a Table Following a Pattern without Using ROWNUM In this article Deepankar discusses how to select records from an Oracle 9i table without using ROWNUM. Deepankar provides a detailed analysis of each SQL statement along with the screenshot of the final out ...

• dml single insert/select or bulk collect/forall Tom, i am currently designing a new database 10g Rel2 and would appreciate your advice on the following Which method would you advise for the following business process OPTION 1 ######## DECLARE CURSOR c1 IS SELECT ..........

• CodeSnip: How to Update Records of a Table in Oracle Using Where Exists Clause After reading this code snippet, you will know how to update records of a table in oracle. Deepankar makes use of the where exists clause to demonstrate the concept. He first provides a short overview of the problem and then provides the solution with the help of relevant SQL statements, screenshots ...

• Delphi CASE statement Works with String Values! in Delphi TIPS :: You've probably tried providing a Case statement with string type selector expression, to find out that it only takes ordinal types (which string is not). Lookin ...

• Customize the built in Outlook Select Names Dialog (or any other) In this article you will learn how to customize the built in Select Names Dialog and use different external Datasources for your own Di ...

• If session_cached_cursors is set,oralce also cache SQL statement in PGA ,if we are using Dedicated s... Hi Tom Good to have a chance to ask a quesion.. I read some discussions about the session_cached_cursors here in the forum. Would you please help to clarify the idea that: 1.If session_cached_cursors is set to non zero, I understand that or ...

• CodeSnip: How to Select the Records from a Table Following a Pattern In this code snippet, Deepankar examines how to select only specific records from a table commencing in a series (even series i.e. 2nd,4th,6th...records or odd series i.e. 1st,3rd,5th.... records and other simple series) in a single query. He provides a detailed analysis of the relevant SQL stateme ...

• Why I can't use stored function in select list of select function. Hi tom, Thanks for accepting my question. my question is why we can't we perform dml operation in query? thanks ga ...

Next: Validating Missing Data by Responding to Data Entry Events