TVS tree technologies is an website which covers most of the technologies to survive in IT industry.In TVSTreeTechnologies, I have provided most of the information for each techonolgy and people who are new to these techonolgies also they can understand easily. In TVStreetechnolgies, covered both frontend and backend technologies.If you have any queries/ anymore information is required on any technologies, please feel free to comment me in comment section below and contact me in Contact US page.
Functions(MIN,MAX,AVG,SUM,COUNT)
Max Syntax & Example:
Select max(sub1) from smarks;
Nested queries:
Select name from smarks where sub1=(select max sub1 from smarks);
Min Syntax & Example:
Select min(sub1) from smarks;
Count Syntax & Example:
Select count(sub1) from smarks;
Avg Syntax & Example:
Select avg(sub1) from smarks;
Sum Syntax & Example:
Select sum(sub1) from smarks;
Aliases:
Syntax with Example:
Select Rollno As P,
Name As Q,
From smarks;
No comments:
Post a Comment