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);
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.
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.
Explore Python’s exciting future! Discover anticipated trends, innovations, and what upcoming releases like Python 3.13 and 3.14 mean for developers and data scientists.
Get ready for Java 25! The September 2025 Inside Java Newsletter is packed with technical videos, Java User Group updates, and essential developer event news. Stay ahead with the latest Java innovations.
Explore how AI tools like ChatGPT are reshaping education, from aiding learning to challenging academic integrity, especially in the realm of college application essays.
Explore the latest developer ecosystem trends: TypeScript’s rapid growth and PHP’s mature, stable presence. Understand their impact on web development and career paths.
Unlock your potential in the IELTS exam! Discover how leveraging recent exam questions can sharpen your skills, build confidence, and boost your score.
Discover Laravel, the open-source PHP framework renowned for its elegant syntax, robust features, and security, making web development enjoyable and efficient.
Discover the powerful features of Laravel 10, the PHP Framework for Web Artisans. Learn how it enhances security, performance, and developer experience for modern web apps.
Discover Laravel, the open-source PHP framework that combines elegant syntax with robust tools for building secure, scalable, and enjoyable web applications. Learn its core strengths.
Comparing Django and FastAPI for modern web development needs. Discover which Python framework excels in performance, development speed, and scalability for your next project.
Choosing between Django and Express.js? Our in-depth 2025 guide compares Python’s Django and Node.js’s Express on performance, security, and scalability.
Choosing between Hadoop and Spark? Discover how hybrid cloud architectures and FinOps practices can maximize your big data ROI and control costs.
Discover the leading cloud storage providers of 2024 and the key trends like AI integration, serverless, and multi-cloud strategies shaping the future of data.
0 Comments