How to get Last record in MySQL?

Posted by vishalneeraj-24503 on 11/27/2013 | Category: Sql Server Interview questions | Views: 1936 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

By using Limit clause in MySQL,we can the Last record.

For ex:-

Select employee_id from employee_master order by employee_id desc limit 1;

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How many ways of getting Last records in SQL-Serve ...

Next > : What do we mean by self-join and cross-join?

Comments or Responses

More Interview Questions by vishalneeraj-24503

What do we mean by self-join and cross-join?
What will be the Error after executing below query? select * from e ...
How many ways Cross join can be written into Sql-Server?
What will be the output of below query? Select * from employee_mast ...
Below query is a which type of join? Select * From employee_master, ...
When does below error occur? The GridView 'grid_view_employee_d ...
How to Concatnate 2 column values to make one column value in SQL-Serv ...
How to Concat 2 Column values in MySQL?

Latest Interview Questions

Which processes implemented sandbox solution?
Which of the following files/programs are not removed by the uninstall ...
What is compatibility level of SQL server 2012?
DBCC SHRINKDATABASE (UserDB, 10); What is the unit of second paramet ...
We can configure individuals to be alerted about sql server agent jobs ...
Which of the following built in tool allows you to changes services ac ...
Which of the following is FALSE regarding the tempdb database?
We can RECOMPILE a stored procedure in SQL server. Which of the follow ...
More ...