Informatics Practices
What is Mathematical function in SQL? Name any two.
SQL Queries
1 Like
Answer
In SQL, mathematical functions are built-in functions that perform mathematical operations on numeric data. POWER
and SQRT
are two examples of mathematical functions.
Answered By
1 Like
Related Questions
What do you understand about Netiquette? Explain any two such etiquette.
Give the output:
import pandas as pd name = ['Rahul','Aman','Karan'] p=pd.Series (name, index= [0,1,2] ) p1 = p.reindex ([1,2,3]) print(p) print(p1)
Mr. Sombuddha, an HR Manager in a multinational company "Star-X World", has created the following table to store the records of employees:
Table: Emp
Eid EName Department DOB DOJ Star1 Dev Sales 1994-08-28 2020-02-14 Star2 Melinda IT 1997-10-15 2021-11-19 Star3 Raj Accounts 1998-10-02 2019-04-02 Star4 Michael Sales 2000-02-17 2020-05-01 Star5 Sajal IT 2001-12-05 2018-06-13 Star6 John Accounts 1995-01-03 2019-07-15 Star7 Julia Sales 1985-11-13 2020-08-19 Predict the output of the following queries that he has written:
(i) Select max(year(DOB)) from emp;
(ii) Select ENAME from emp where month(DOJ) = 11;
(iii) Select length(EName) from emp where Department = "IT";
Write a Python code to create a dataframe with appropriate headings from the list given below:
['S101', 'Amy', 70], ['S102', 'Bandhi', 69], ['S104', 'Cathy', 75], ['S105', 'Gundaho', 82]