<div>
You could use the LIMIT command, like this: 
<pre><code id="code-8033932">SELECT ER_RL_GE_LOG.ID_GE, ER_RL_GE_LOG.LOGIN_DATE, ER_RL_GE_LOG.LOGIN_TIME 
FROM ER_RL_GE_LOG 
ORDER BY ER_RL_GE_LOG.LOGIN_DATE DESC , ER_RL_GE_LOG.LOGIN_TIME DESC LIMIT 1,1;</code></pre>
<br />
See this link for details:<br />
<a href="http://www.plus2net.com/sql_tutorial/second-highest.php" rel="ugc">http://www.plus2net.com/sql_tutorial/second-highest.php</a><br />
<br />
Cheers
</div>


You could use the LIMIT command, like this:

SELECT ER_RL_GE_LOG.ID_GE, ER_RL_GE_LOG.LOGIN_DATE, ER_RL_GE_LOG.LOGIN_TIME 
FROM ER_RL_GE_LOG 
ORDER BY ER_RL_GE_LOG.LOGIN_DATE DESC , ER_RL_GE_LOG.LOGIN_TIME DESC LIMIT 1,1;


See this link for details:
http://www.plus2net.com/sql_tutorial/second-highest.php [http://www.plus2net.com/sql_tutorial/second-highest.php]

Cheers

<div>
Thanks for response ,<br />
i get syntax error in ORDER BY clause ..
</div>


Thanks for response ,
i get syntax error in ORDER BY clause ..

<div>
i forgot to mention that the query is built in access 2010 .
</div>


i forgot to mention that the query is built in access 2010 .

<div>
i just changed in the last order by to include asc in both .LOGIN_DATE and .LOGIN TIME and it worked perfectly.<br />
Thank you for assistance!!
</div>


i just changed in the last order by to include asc in both .LOGIN_DATE and .LOGIN TIME and it worked perfectly.
Thank you for assistance!!

<div>
<div class="content wysiwyg-content">
Hello experts ,<br />
i have a query that returns me top 2 records from a table ordered by descending order for date and time fields.I want to select only the second row .How can this be done ?<br />

<pre><code id="code-8033900">SELECT TOP 2 ER_RL_GE_LOG.ID_GE, ER_RL_GE_LOG.LOGIN_DATE, ER_RL_GE_LOG.LOGIN_TIME
FROM ER_RL_GE_LOG
ORDER BY ER_RL_GE_LOG.LOGIN_DATE DESC , ER_RL_GE_LOG.LOGIN_TIME DESC;</code></pre>
</div>
</div>


Hello experts ,
i have a query that returns me top 2 records from a table ordered by descending order for date and time fields.I want to select only the second row .How can this be done ?

Select Query

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.