Subject : SQL
How to find salary of friends whose salary is Second highest;
Table Name: friends
| friendsName | salary |
| Nihar | 30000 |
| Bihar | 40000 |
| Saiyar | 50000 |
| Nahar | 55000 |
Query :
SELECT friendsName,MAX(salary) as salary FROM friends
WHERE salary < (SELECT MAX(salary) FROM salary);
Despite frequent predictions of its demise, PHP remains a cornerstone of web development. Discover why this ‘immortal’ language continues to evolve and power millions of websites.
Prepare for your IELTS Speaking test with expert strategies, potential November 2025 question insights, and essential tips to achieve a Band 9 score, especially for test-takers in Germany.
Stay ahead of the curve with our comprehensive guide to the latest technology news and innovations shaping our world, from AI to IoT and beyond.
Explore how Laravel excels in large-scale applications, integrates with Domain-Driven Design, and the exciting potential of the new Laravel Cloud API.
Discover why Python is the undisputed leader in data science, exploring its key advantages, essential libraries, and profound impact on AI, machine learning, and data-driven innovations.
Create Laravel Project Through Docker — No Need to Install PHP, MySQL, or Apache on Your Local Machine In this tutorial, I’ll show you how to create and run a full Laravel project using Docker containers. That means you won’t have to install PHP, MySQL, or Apache...
Despite frequent predictions of its demise, PHP remains a cornerstone of web development. Discover why this ‘immortal’ language continues to evolve and power millions of websites.
Prepare for your IELTS Speaking test with expert strategies, potential November 2025 question insights, and essential tips to achieve a Band 9 score, especially for test-takers in Germany.
Stay ahead of the curve with our comprehensive guide to the latest technology news and innovations shaping our world, from AI to IoT and beyond.
Explore how Laravel excels in large-scale applications, integrates with Domain-Driven Design, and the exciting potential of the new Laravel Cloud API.
Discover why Python is the undisputed leader in data science, exploring its key advantages, essential libraries, and profound impact on AI, machine learning, and data-driven innovations.
Create Laravel Project Through Docker — No Need to Install PHP, MySQL, or Apache on Your Local Machine In this tutorial, I’ll show you how to create and run a full Laravel project using Docker containers. That means you won’t have to install PHP, MySQL, or Apache locally on your computer. By the end of this guide, you’ll have a fully functional Laravel development...
Discover Project Valhalla’s impact on Java performance! Explore JEP 401 (Value Classes & Objects) and learn how to try the new Early Access build for a faster, leaner JVM.
The world of AI is evolving at lightning speed. Discover why keeping up with the latest Artificial Intelligence news and trends is essential for everyone.
Explore PHP’s incredible journey to its 30th year and what hypothetical future versions like PHP 8.5 could mean for performance, developer experience, and web innovation.
Stay ahead in your IELTS preparation! Discover the latest test changes, essential resources, and expert tips to achieve your target score with confidence.
Dive into the forefront of innovation with insights into nanotechnology, biotechnology, green tech, and other groundbreaking scientific research shaping our future.
A 2025 survey reveals 83% of developers use outdated Python. Discover why upgrading to modern Python is critical for web development performance, security, and innovation.
Dive into the world of Java build tools like Maven and Gradle. Discover how to optimize your build process for speed, safety, and a superior developer experience.
Dive into the world of AI tools with our comprehensive guide. Explore categories, benefits, and top applications transforming industries and daily life in 2024.
Get ready for PHP 8.5, scheduled for release on November 20, 2025! Explore the upcoming features, performance boosts, and essential migration strategies for a smoother transition.
Unlock a higher IELTS Speaking score with a consistent daily English practice routine. Discover expert tips and actionable strategies to boost your fluency, vocabulary, and confidence for test day.
Get an early look at Python 3.14, slated for 2025! Explore expected features, performance boosts, and how it will shape Python development and data science.
The world of AI evolves at lightning speed. Discover why staying informed on the latest AI news, breakthroughs, and industry trends is essential for everyone.
Stay ahead in web development with a weekly dive into PHP news, articles, events, and essential links. Discover the power of continuous learning for PHP professionals.
Discover expert strategies and essential resources to ace the IELTS Speaking Test. Learn how to boost your fluency, vocabulary, and confidence for a top score.
0 Comments