Resources
Answers
Examples
Sign in
Get Started
What do you want to save?
Add Code snippet
New code examples in category SQL
Jerry Kerbo
2021-08-28 02:25:03
oracle insert multiple rows into same table
INSERT INTO my_table (col1, col2) SELECT 8000, 0 FROM DUAL UNION ALL SELECT 8001, 5 FROM DUAL;
Add solution
David Fischer
2021-08-28 02:24:01
java code to save excel data to mysql
import java.io.*; import java.sql.*; import java.util.*; import java.util.regex.*; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.poifs.filesystem.POIFSFileSystem; public class Insert { pub...
Add solution
Andrew Case
2021-08-28 02:24:01
sql if else in select
IF Boolean_expression BEGIN -- Statement block executes when the Boolean expression is TRUE END ELSE BEGIN -- Statement block executes when the Boolean expression is FALSE END
Add solution
EnglishAdam
2021-08-28 01:56:02
how to get the size of the database in postgresql
SELECT pg_size_pretty( pg_database_size('dbname') );
Add solution
Ione was here
2021-08-28 01:22:01
sql query to check if column contains alphabets
SELECT * FROM table_name WHERE CAST(PRIME_KEY AS STRING) RLIKE '([0-9]+[a-z]+)'
Add solution
Styfle
2021-08-28 00:46:02
sqlite woth cmake
find_package (SQLite3) include_directories(${SQLite3_INCLUDE_DIRS}) target_link_libraries (${OUT_TARGET} ${SQLite3_LIBRARIES})
Add solution
Jong-hyeon-yeo
2021-08-28 00:44:02
postgres update column with value from another table
UPDATE t1 set "Column" = t2.column from t2 where t2.id = t1."Id";
Add solution
Slendev
2021-08-28 00:16:02
second highest salary in sql
SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP N salary FROM #Employee ORDER BY salary DESC ) AS temp ORDER BY salary
Add solution
Erik Schmidt
2021-08-27 23:51:02
is not recognized built in function name
SELECT [dbo].[Split_On_Upper_Case] ('SaiBharath')
Add solution
Joan Whitch
2021-08-27 23:36:01
postgresql port 5432 not open
search "postgresql.conf" file in file directory Open File and check Port No
Add solution
‹
1
2
...
395
396
397
398
399
400
401
402
403
404
›
Best helpers
daily
weekly
monthly
for 3 months
Geoff Gerrietts
+5
Jeff Calderwood
+5
show more
This website uses cookies to make IQCode work for you. By using this site, you agree to our
cookie policy
Welcome Back!
Sign up to unlock all of IQCode features:
Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings
Sign in
E-mail
Password
Recover lost password
Log in
Or log in with
Not registered?
Sign up takes less than a minute
Create a Free Account
Sign up to unlock all of IQCode features:
Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings
Sign up
Email
Password
Sign up for free
Or sign up with
By signing up, you agree to the
Terms and Conditions
and
Privacy Policy
. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.