Display employee name, designation, Dob who are born in the same year.

Emono ename Designation Dob
101 Raj Developer 24-06-1992
102 mahesh Engineer 15-06-1992
103 Rajesh Mechanic 02-02-1991
104 suresh Jr Engineer 01-01-1990

Afsar

• Oct 25th, 2017

TD QUERY:
SELECT EXTRACT (YEAR FROM DOB), ename, Designation, Dob
FROM TABLE TAB1
GROUP BY EXTRACT (YEAR FROM DOB)

Answer Question  Select Best Answer

Sudha

• Apr 2nd, 2018

NULL is not a data type. The key word NULL is used to mention the unknown or missing values of data.
For ex: while registering sign up form there are few fields which are not mandatory and if user didnt fill those non mandatory fields then those values we can save it as null in the data table.

Dhileep

• Oct 24th, 2017

We cant able to mention particular data type for null.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Parished.D Chennai India

• Apr 24th, 2007

---

create table ee (eno int, ename varchar(200), sal int)

insert into ee values(1, 'a', 2000)
insert into ee values(2, 'b', 6000)
insert into ee values(3, 'c', 8000)

select ENO, ENAME, min(sal) AS SAL from ee group by eno,ename having min(sal) > 5000

Aman Gupta

• Jul 15th, 2024

SELECT Emp_Name, MIN(Salary) FROM Employee
GROUP BY Emp_Name
HAVING MIN(SALARY) > 5000

Arshad

• Jul 30th, 2023

SELECT ENO, SUM(SALARY)
FROM EE
GROUP BY ENO
HAVING SUM(SALARY) > 5000

Improve Answer