get second maximum date from tables.
- 1 Answers
- 3137 Views
- I also Faced
- E-Mail Answers
get second maximum date from tables...
Answer / guest
select dateofjoining from employees group by dateofjoining
order by dateofjoining desc limit 1 offset 1;
| Is This Answer Correct ? | 3 Yes | 0 No |
More Postgre Interview Questions
Explain about the command enable debug?
What is postmaster in postgresql?
What is toast in postgres?
Who owns postgres database?
How does clustering in improving the performance?
What is performance_schema?
How do I enable remote access to postgresql database?
List different advantages of postgresql?
What is the default postgres database?
What type of database is postgres?
What is a user view?
How to check whether PostgreSQL server is up and running?
Categories
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
