Most voted questions in Database

0 votes
0 answers

DECODE function in SQL server

How can I use DECODE() function in ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
• 38,010 points
338 views
0 votes
0 answers

SQL: IF clause within WHERE clause

In MS SQL, is it feasible to ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
• 38,010 points
288 views
0 votes
0 answers

Display data from SQL database into php/ html table.

I want to display one of my ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
• 38,010 points
634 views
0 votes
0 answers

Shortcut for changing the editor font size in Oracle SQL Developer

Is there a shortcut in Oracle SQL ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
• 38,010 points
1,358 views
0 votes
0 answers

Replacing NULL with 0 in a SQL server query

I created a query, and the first ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
• 38,010 points
240 views
0 votes
0 answers

Reset AutoIncrement in SQL Server after Delete

In a SQL Server database table, I ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
• 38,010 points
723 views
0 votes
0 answers

SQL Server : Arithmetic overflow error converting expression to data type int

I'm getting this error: msg 8115, level 16, ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
885 views
0 votes
0 answers

Find max and second max salary for a employee table MySQL

Assume you are given the following straightforward ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
951 views
0 votes
0 answers

How to open .SQLite files

On Windows, I'm attempting to open an ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
304 views
0 votes
0 answers

SQL query for distinct professors and courses

There is a database on instructors, departments, ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
19,352 views
0 votes
0 answers

SqlServer: Login failed for user

I created a pretty straightforward JDBC login ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
481 views
0 votes
0 answers

Merge 2 tables in SQL and save into 1 new table

I have two tables with the same columns. Table ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
306 views
0 votes
0 answers

Difference of two date time in sql server

Is there a method to use SQL ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
276 views
0 votes
0 answers

How to display two digits after decimal point in SQL Server?

I want to return the value of ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
937 views
0 votes
0 answers

Connection string using Windows Authentication

I'm building a website, however, I utilize ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
3,028 views
0 votes
0 answers

Why do you create a View in a database?

When and why does a database owner ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
• 38,010 points
316 views
0 votes
0 answers

SQL query to select data between two dates and times

My table contains a [time] field that ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
2,029 views
0 votes
0 answers

SQL how to compare two tables for same data content?

I have two tables, TableA and TableB, ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
711 views
0 votes
0 answers

How to fetch the nth highest salary from a table without using TOP and sub-query?

I was recently requested to create a ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
1,139 views
0 votes
0 answers

SQL Server Insert if not exists

I want to add data to my ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
1,827 views
0 votes
0 answers

Real life example, when to use OUTER / CROSS APPLY in SQL

With a colleague, I've been researching CROSS/OUTER ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
590 views
0 votes
0 answers

Self Join to get employee manager name

Hello, the columns in my employee table ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
301 views
0 votes
0 answers

What is the syntax to drop a Stored Procedure in SQL Server 2000?

In SQL Server 2000, how do you ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
425 views
0 votes
0 answers

When to use "ON UPDATE CASCADE"

I frequently use ON DELETE CASCADE, but ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
1,081 views
0 votes
0 answers

ORA-01476: "divisor is equal to zero" for SQL query (Oracle 10g)

I'm creating a SQL query with Oracle ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
520 views
0 votes
0 answers

How to Return Multiple Values from CASE clause in Where Condition

I have a condition where utilizing the ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
• 38,010 points
1,735 views
0 votes
0 answers

Return date as ddmmyyyy in SQL Server

I require the date in the format ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
• 38,010 points
1,041 views
0 votes
0 answers

Bulk Record Update with SQL

In a SQL Server 2008 environment, I ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
• 38,010 points
662 views
0 votes
0 answers

How to select the last record of a table in SQL?

Here is an example of code that ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
• 38,010 points
875 views
0 votes
0 answers

How can I delete using INNER JOIN with SQL Server?

In SQL Server 2008, I want to ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
• 38,010 points
553 views
0 votes
0 answers

The node to traverse cannot be null (Hibernate SQL)

I'm using hibernate to run the following ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
• 38,010 points
543 views
0 votes
0 answers

Altering column size in SQL Server

How to change the column size of ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
• 38,010 points
423 views
0 votes
0 answers

Get all table names of a particular database by SQL query?

I'm developing a program that can interact ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
284 views
0 votes
0 answers

Reset identity seed after deleting records in SQL Server

A SQL Server database table has had ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
476 views
0 votes
0 answers

Caused by: android.database.sqlite.SQLiteException: no such table: (code 1) Android

A SQLite database is present in our ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
2,438 views
0 votes
0 answers

Getting java.sql.SQLException: Operation not allowed after ResultSet closed

The following code throws an exception when ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
1,676 views
0 votes
0 answers

If else in stored procedure sql server

I have created a stored procedure as ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
756 views
0 votes
0 answers

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I experimented with the following code in ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
5,648 views
0 votes
0 answers

What's the difference between RANK() and DENSE_RANK() functions in oracle?

What distinguishes the functions RANK() and DENSE ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
278 views
0 votes
0 answers

How to store image in SQLite database

I want to upload an image from ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
2,730 views
0 votes
0 answers

SQL Update from One Table to Another Based on a ID Match

Account and credit card numbers are stored ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
982 views
0 votes
0 answers
0 votes
0 answers

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

I've been attempting to solve a significant ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
1,535 views
0 votes
0 answers

Get size of all tables in database

A sizable SQL Server database has been ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
257 views
0 votes
0 answers

How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?

I can't seem to link from a ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
1,806 views
0 votes
0 answers

SQL Server Configuration Manager not found

I cannot locate the SQL Server Configuration ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
• 38,010 points
475 views
0 votes
0 answers

How to convert SQL Server's timestamp column to datetime format

Is there a simple way to convert ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
• 38,010 points
1,364 views
0 votes
0 answers

Convert SQL to LINQ Query

I need to use the following SQL ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
• 38,010 points
3,461 views
0 votes
0 answers

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]

I have this Java program: MySQLConnectExample.java import java.sql.*; import java.util.Properties; public ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
• 38,010 points
1,959 views
0 votes
0 answers

HAVING without GROUP BY

Does the following make sense in terms ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
• 38,010 points
1,071 views