select trunc(months_between(Sysdate,EDOB)/12)Age from emp;

we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz

Question Posted / santhi k

Answer Posted / santhi k

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the default sql server instance name?

1009

What are two difference between sql azure and azure tables?

159

Explain sub-query?

933

What is difference between unique and primary key?

889

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1147

How to delete duplicate rows in sql server?

1085

How to modify an existing user defined function?

1082

What is index in an assignment?

936

how many clustered indexes can be created on a table? : Sql server database administration

1128

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

887

Do you know exporting and importing utility?

1022

Why is normalisation important?

927

What is master database? : SQL Server Architecture

998

What do you know about system database? : SQL Server Architecture

970

What do you mean by 'normalization'?

1042