write a query to display diference between two dates in sql
server
Answers were Sorted based on User's Feedback
Answer / jayesh l lolariya
select datediff(dd,'03-03-2008',getdate()) as dataDiff
| Is This Answer Correct ? | 7 Yes | 3 No |
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?
29 Answers Alps, Aricent, Bank Of America, Wipro,
What is the starting oracle error number? What is meant by forward declaration in functions?
what is table? : Sql dba
What is difference between cursor and ref cursor?
What is the difference among union, minus and intersect?
How can I delete duplicate rows?
Explain what is an index?
What is rule base and cost base optimizer?
how to get second highest salary in SQL(as/4000
What is pl sql variable?
Explain constraints in sql?
Does access use sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)