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
How check triggers in sql server?
what's the difference between a primary key and a unique key? : Sql server database administration
What is read committed?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are the main sources of data?
What is the recursive stored procedure in sql server?
Can the query output be sorted by multiple columns in ms sql server?
what is a join and explain different types of joins? : Sql server database administration
How to view existing indexes on an given table using sys.indexes?
what is denormalization and when would you go for it? : Sql server database administration
What is the difference between migration and upgradation in sql server?
What is ms sql server service broker?
When would you use sql joins?
Define union, union all, minus, intersect?
What are relationships and mention different types of relationships in the dbms