Most voted questions in Database

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
341 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
515 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
112 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
448 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
380 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
527 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
142 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
5,889 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
262 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
121 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
128 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
495 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
1,522 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
176 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
1,227 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
402 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
452 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,116 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
294 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
138 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
258 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
522 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
103 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
777 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
680 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
502 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
500 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
361 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
300 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
228 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
127 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
199 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
1,319 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
974 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
432 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
3,065 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
81 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
1,794 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
518 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,072 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
123 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,103 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
285 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
961 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
2,233 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,479 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
520 views
0 votes
0 answers

How to remove foreign key constraint in sql server?

In order to enter values of my ...READ MORE

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

Select Rows with id having even number

I'm passing a straightforward query that looks ...READ MORE

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