What will be the result of the query given below?SELECT emp_id,‘ACTIVE’ AS STATUS,emp_id * 3.14 AS emp_pi,UPPER (lname) AS last_nameFROM employee;
What will be the output of a query given below?SELECT person_id, Fname, lnameFROM person;
In the following query, what does “person_id” stands for?CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20) , CONSTRAINT pk_person PRIMARY KEY (person_id));
If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the given query?SELECT emp_idFROM personORDER BY emp_id;