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 |
How do I change the order of columns in postgresql?
Does unique constraint create index postgres?
Put some light on multi-version concurrency control?
What is postgresql?
What is pg server?
How do I find the size of a postgres table?
How do you create a table in pgadmin 4?
What is postgresql dba?
Compare ‘postgresql’ with ‘nosql’?
Do indexes speed up queries?
Is mysql faster than postgresql?
What is ora2pg?
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)