SQL queries examples

SELECT NAME FROM CITY WHERE POPULATION>120000 AND COUNTRYCODE='USA';

SELECT * FROM CITY;

SELECT * FROM city WHERE COUNTRYCODE='JPN';

SELECT NAME FROM CITY WHERE COUNTRYCODE='JPN';

SELECT DISTINCT CITY FROM STATION WHERE (ID%2)=0;



Comments

Post a Comment

Popular posts from this blog

Spring boot versions : Detailed explanation of the different versions and releases of Spring Boot (AI Generated)

 Here’s a detailed explanation of the different versions and releases of Spring Boot , focusing on what’s most relevant from a Java Developer / Software Developer interview perspective — followed by a visual timeline . 🚀 What is Spring Boot? Spring Boot is a tool built on top of the Spring Framework to make it easier and faster to build, test, and deploy Java applications — especially REST APIs and microservices. Key Concepts: Auto-Configuration Embedded servers (Tomcat/Jetty) Opinionated defaults Spring Boot Starters Actuator for Monitoring 📅 Major Spring Boot Versions & Features (Interview-Centric) 🔹 Spring Boot 1.x (2014–2017) Spring Boot 1.0 released in April 2014 Features: Introduction of @SpringBootApplication Embedded Tomcat , Jetty , or Undertow Auto-configuration and Starters Properties-based configuration ( application.properties ) Basic Spring Actuator Interview Notes: Understand why Spring Boot was introduced ...
Read more

download youtube videos java program ( AI generated)

Downloading and processing YouTube videos using code requires using YouTube's APIs or third-party libraries, as well as tools for trimming the video. Here’s an outline of how you can do it in Java: --- Steps to Write the Program 1. Prerequisites Install Java Development Kit (JDK). Install FFmpeg (for video trimming). Add youtube-dl (or an equivalent library like yt-dlp) for video downloading. 2. Required Libraries You’ll need the following: ProcessBuilder (built-in Java class to execute system commands). Any library for parsing JSON, such as Gson or Jackson (to process metadata if needed). 3. Implementation Here's the Java code to achieve this: --- import java.io.IOException; public class YouTubeDownloader {     public static void main(String[] args) {         String videoUrl = "https://www.youtube.com/watch?v=your_video_id";         String outputFileName = "output.mp4";         String startTime = "00:01:00"; // Forma...
Read more

Java Spring Framework versions and their major releases ( AI Generated )

Image
 Sure! Here’s a detailed breakdown of the different Java Spring Framework versions and their major releases , from the perspective of what a Java Developer or Software Developer should know for interviews. This includes evolution, features , and what might be commonly asked. ✅ Overview of Spring Framework The Spring Framework is a powerful, lightweight framework used for developing Java applications, especially enterprise-level applications. It provides comprehensive infrastructure support for developing Java applications and is known for: Dependency Injection (DI) Aspect-Oriented Programming (AOP) Spring MVC (Web Framework) Data access with JDBC, JPA Spring Boot (for microservices) 📅 Spring Framework Major Versions and Key Features 🔹 Spring Framework 1.x (2004) Highlights: Initial release by Rod Johnson (author of Expert One-on-One J2EE Design and Development ) Introduced IoC (Inversion of Control) and AOP Replaced heavy EJB-based solutions ...
Read more