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

Answer Posted / santhi k

Answer i submitted is for Oracle not for SQL server.
Sorry!
Plz always mention the RDBMS which you are using ,in the
post.
Bcoz,This Oracle query may not work in other RDBMS.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the return type of executeupdate ()?

690


What is isnull() operator?

774


Is there any difference between the primary key and unique key?

744


Equi join and non equi join is possible with sql server?

658


What does the not null constraint do?

744






How do you delete a data source?

749


What are the requirements on sql server network connections?

683


Define Unique Key?

761


What is difference between createstatement and preparedstatement?

784


Can I save my report as html, excel or word? : sql server management studio

726


Explain identity in sql server?

714


Explain the truncate command? : SQL Server Architecture

770


How to display a past time in days, hours and minutes?

738


What does normalization do to data?

720


What is sql server programming?

757