Aggregate Function

-

 Data base functions are called Aggregate Functions.

 These are also called Scalar functions. 

1. sum()

2. min()

3. max()

4. avg()

All aggregate functions use select query.

In scalar program we don't use Non-Query.

Ex- 

select sum(Column_name) from Table_name;

Note:- column should not be empty.


Comments

Post a Comment

Popular posts from this blog

UnEditable TextBox (For Security)

-
   <asp:TextBox ID="someId" runat="server" oncopy="return false" onpaste="return false" oncut="return false" ondelete="return false" Text="hi"></asp:TextBox> Note:- A textbox will be appeared in the screen on which you can not do any operation wheather  it is to copy the data , cut the data, paste the data and delete the data  - this is used for security purposes.
Read more

Introduction To HTML

-
📘 HTML – Basics & Concepts 🔹 HTML Html is tag based or browser oriented or text based language. HTML stands for hypertext markup language. 🔹 Terminology Hyper :- hyper represents the next document. Text :- text is a collection of words (char, number or special characters) Markup :- it is basically an HTML library where all the tags are defined (it communicates directly with the browser) Language :- it works as a mediator between a user and computer 🔹 Tag-Based Structure .........Html has a tag-based structure......... <H1>this is a heading</H1> Here, the content between the tags is called inner HTML 🔹 Types of Tags Open tag → <br> , <hr> , <i> , <b> , <img> Closed tag → <h1></h1> 🔹 Development Rules Create your own directory Put all the resources into the directory (Audio, video, image, library, api or other) Don't put spaces between your project's name My project ✗ Myproject ✓ 🔹 Important Tags 1) <del> Th...
Read more

Grid View Paging

-
  Grid View paging- Grid view paging is used when we have to read the data in bulk then we divide the complete data records into pages consists 10 records in one page. SqlDataAdapter - It is used for Grid View Paging Data Adapter reads data in group of 10 records unlike DataReader which reads the data line by line. DataSet - DataSet Object is created, it accepts the data in bulk. Fill() - Fill() is used. CODE - protected void display() { //Connection Code string s = ConfigurationManager.AppSettings["db"]; cn = new SqlConnection(s); cn.Open(); //DataSet Object DataSet ds = new DataSet(); string s = "select * from Videodb"; //SqlDataAdapter object SqlDataReader adp = new SqlDataAdapter(); adp.Fill(ds); GridView1.DataSoruce = ds; GridView1.DataBind(); } Source code-   <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"              Height="589px" Width="483px" OnPageIndexChanging="click...
Read more