Kayıtlar

Mart, 2022 tarihine ait yayınlar gösteriliyor

[Spring] Application.properties

spring.jpa.hibernate.ddl-auto=update spring.datasource.url=jdbc:mysql://localhost:3306/ yourDBName ?useUnicode=true&useLegacyDatetimeCode=false&serverTimezone=UTC spring.datasource.username=root spring.datasource.password=1234 spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.jpa.show-sql=true spring.jpa.properties.hibernate.format_sql=true

[SQL] en cok maas alan 3. kisiyi bulan SQL sorgusu

select salary , a.id from (select salary,id from Employee order by salary desc limit 3) a order by salary asc limit 1; veya SELECT * FROM db.employee ORDER BY `salary` DESC LIMIT 1 OFFSET 2;