Common Sql Interview Questions and Answers

Create a SQL table tblemployes then try these queries
Structure of tblemployes table and insert some data into this table.

tb lemployee
1.How to get a employee record with max salary ?

2.How to get max salary  in tblemployes ?

3.How to get 2nd highest salary  in tblemployes ?

4.How to get emp name,  highest salary and department ?

5.How to get   highest salary of each department ?

6.How to get   number of employee in each department ?

Here are a few hand-picked articles for you to read next:

Anuj Kumar

I'm Anuj kumar a web developer with 4+ year experience .I write blogs in my free time. I love to learn new technologies and share with others. I founded PHPGurukul in September 2015. The main aim of this website to is provide php , jquery , mysql , phpoops and other web development tutorials. I am trying best effort to make PHPGurukul useful for every single moment spend on this website. If you think this website is useful to visit please share with your friend and buddies.

Recommended Tutorials for you

You may also like...