Monday, March 10, 2008

Define having , order by ,group by

Having- clause set the condintion on the group by clause.
Order By-Order by clause allows sorting of query results by one or more columns.each sort can be either asc of des.

Group by – Group By is used in select statement to divide the output of table into groups.

1transcation log
every changes to the databse whether it is the result of a single ipdate stm or a grouped set of sql stm automatically record in the system table.this table is called tranc log.

No comments: