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 |
What is difference between postgresql and mysql?
What is the difference between sql and postgresql?
Does postgres support clustering?
What is a ctid?
i have three table 1. student (stuid,name) 2. subject (subid,sname,studid) 3. marks (subid,studentid,marks) i want the reslut of how as got max marks in each subject sudentname,max(marks), name abc,70,nikitha
Is postgresql better than oracle?
How to select distinct on multiple columns?
What is join and how many types of joins?
How do you define a composite key?
How to setup postgresql sysv startup script?
What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?
How do I start postgresql?
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)