Write an SQL query to get third maximum salary of an employee from a table named empl - Site Owners Forums

		Site Owners Forums - Webmaster Forums > Web Programming > Programming General > PHP / mySQL
Write an SQL query to get third maximum salary of an employee from a table named empl

FAQ

Calendar

Today's Posts

Notices

Welcome to SiteOwnersForums.com #1 Webmasters Community Online

You are currently viewing our forum as a guest which gives you limited access.
Membership is absolutely FREE and registration is FAST & SIMPLE so please, Register Today and join one of the friendliest communities on the net!
If you have any problems with the registration process or your account login, please contact us.

Thread Tools

Rate Thread

Display Modes

06-01-2018, 10:16 AM	#1
Pavan Techn Registered User Join Date: Mar 2018 Posts: 341	Write an SQL query to get third maximum salary of an employee from a table named empl SELECT TOP 1 salary FROM ( SELECT TOP 3 salary FROM employee_table ORDER BY salary DESC ) AS emp ORDER BY salary ASC; __________________ Bulk SMS services provider in Coimbatore\|Software Development Company in Coimbatore\|Web design company in Coimbatore \|erp Crm software in coimbatore

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

All times are GMT -7. The time now is 08:55 PM.