Search In
The increasing number of online businesses has increased the flow of information for social media users. Hint any keyword to the people and the first thing they’ll do is search for it on Google to glean more information about the topic. Here co
Binary search is an efficient linear search algorithm which is also known as half-interval search or logarithmic search. In this algorithm we try to find the target value inside the linear structure. The range should be sorted in order to apply binar
Example of Stored Procedure using INOUT mode parameter:
INOUT mode is used when you pass and want to get the result using same parameter. Using INOUT mode parameter we can pass the argument to the Stored Procedure and also can get the result with th
RAID or Redundant Array of Independent Disks is a method by which we store the same data in several places on different hard disks. By Implementing RAID we can Make Input/Output operation to overlap in good proportions and it also Improve the Perform
SQL Truncate Table
Using this statement you can remove all data of rows or column ( complete data ) not table. In this there is no where clause but where clause is available in Delete statement. Truncate table is faster than Delete statement
Note -
SQL rename statement is used to change the name of the table in database . Sometime we want to change our table name i.e we want to give some useful name of our table . SO by using this statement we can do the same .
Syntax
Rename oldTableName to N
SQL SELECT DATE
if you want to retrieve a date from database,use this staement. For eg. you want to find a particular date from a database, this statement is the answer.
1)For example: let's see the query to get all the records after '2013-12-12'
Count ( ) In SQL Database this is a function which return no of rows from a table in Database . Generally this is used in SQL select statement and count the no. of records in a table .
Syntax ->
select count ( expression_name ) from table_name w
Avg ( ) function is used to return the average of numeric column . If in a table there is null value then it ignored that value .
Syntax :
select avg ( column_name ) from table_name where clause ; // where clause is optional
Example :
Table name
This function is used to get the maximum value from the selected field .
Syntax :
select max ( column_name ) from table_name ;
Example :
Table name : Employee_Info
Id Employee_name Employee_Age Employee _Salary
1
