The ORDER BY clause is used in the SQL SELECT statement to order the data in ascending or descending order, this may help us get a better look when analyzing data, the ORDER BY clause can sort numeric as well as alphabetical data in both ascending and descending order.
SQL ORDER BY Clause Syntax
SELECT column_name(s) FROM table_name ORDER BY column ASC|DESC ASC as ascending order
DESC as descending order
Example:
SELECT * FROM Dept ORDER BY SalOR
In the SQL SELECT Statement we can also group data upon certain conditions, the GROUP BY condition can only be applied if we have redundant values in at least one column upon which we can group things.
If every column of each row has unique value then the GROUP BY clause will not group any thing together and will not give proper results.
The GROUP BY clause also requires the use of an aggregate function, which does some mathematical calculations upon the grouped data.
Whenever you want to retrieve data from your table, there are times that you don’t want to pull all the information. You can retrieve data from the database by using the WHERE clause to filter data based on your criteria.
The WHERE clause in SQL is used to filter out data or to simply select specific data to perform the desired operation.
The WHERE clause can be used in SELECT, UPDATE, and DELETE statement. It is needed to filter what data to select, update, or delete.
One of the problems that I encounter when I started programming is on how to save record to a database.
I feel I need to share the knowledge that I gained within 10 years of my experience so that other programmer who would like to learn will benefit on this tutorial.
SQL stands for Structured Query Language and is the standard for accessing and or manipulating a database.
This tutorial will use the ISO standard so that you can apply the code that I will provided here.
When you insert data into your table you may need to update it sometimes. Not so often we inserted or updated a wrong data. That’s why there is a Delete statement.
To delete some record from the database tables we use the SQL Delete statement, the Delete Statement deletes the data row from the table which meets the condition specified in the where clause.
The delete command has the following syntax:
This tutorial will teach you on how to create reports in Visual Basic .NET 2008 using Crystal Reports. This is a step by step guide on how I create the report on "Weekly Sales Report using Crystal Reports".
This guide is not intended for advance user. So please don't react if you find a basic explanation on this tutorial.
This assumes that you have already attached the database that is included in the zip file of "Weekly Sales Report ".
When you insert record to your table there are some cases that you need to modify the data. Or you may want to update it to the latest record.
The SQL update is there to help us modify the existing values of the table, the SQL update statement used the same column name as insert statement and the new value that you want to placed and the table name to update the data successfully.
The syntax of SQL update statement is as follows:
