Latest questions in Database

0 votes
1 answer

Why is the object value not updating in MongoDB?

There could be several reasons why an ...READ MORE

Dec 31, 2024 in Database by Navya
180 views
0 votes
0 answers

DFS PUT Command gives error on Windows

When i run DFS PUT command on ...READ MORE

Jul 22, 2024 in Database by anonymous

edited Mar 4 68 views
0 votes
0 answers

what kind of a nosql store is azure table storage

what kind of a nosql store is ...READ MORE

Dec 15, 2023 in Database by Priyanka
• 4,500 points
808 views
0 votes
0 answers

Cannot connect to SQL server

cannot connect to SQL worked well before ...READ MORE

Nov 10, 2023 in Database by rakshatha

edited Mar 5 159 views
0 votes
0 answers

Create a SQL enter script from an Excel worksheet

I have a large excel worksheet that ...READ MORE

Sep 8, 2023 in Database by Satyawrat
• 460 points
756 views
0 votes
0 answers

MongoDB convert type of an element in array

In MongoDB, I have a object array ...READ MORE

Aug 7, 2023 in Database by Ramkumar

edited Mar 5 138 views
0 votes
0 answers

How to add crud operation in Laravel via ajax?

I have created a project in Laravel ...READ MORE

Jul 13, 2023 in Database by Muhammad

edited Mar 5 41 views
0 votes
0 answers

How to create Login and Register in Laravel verify by OTP?

I want to create a project in ...READ MORE

Jul 13, 2023 in Database by Muhammad

edited Mar 5 92 views
0 votes
0 answers

How to Extract Tally ODBC to Sales Register table Excel, items wise In SQL Statement

How to Extract Tally ODBC to Sales ...READ MORE

Jun 17, 2023 in Database by Arun

edited Mar 5 40 views
0 votes
0 answers

How do I delete rows from two tables with ID in MySQLi using php?

I want to delete rows in two ...READ MORE

May 25, 2023 in Database by Hannes

edited Mar 5 71 views
0 votes
0 answers

Select employee details of dept number 10 or 30

Dept Table:                     DeptNo Dname Loc 10 Accounts Bangalore 20 IT Delhi 30 Production Chennai 40 Sales Hyd 50 Admn London Emp ...READ MORE

Feb 12, 2023 in Database by Nischitha

edited Mar 4 61 views
0 votes
0 answers

why this error ? ERROR Cannot add or update a child row a foreign key constraint fails

create table per( sl_no int UNIQUE NOT ...READ MORE

Dec 13, 2022 in Database by abc

edited Mar 4 61 views
0 votes
0 answers

I am having a forbidden error response when I try to login to Docker Desktop on a Windows OS

I am new to docker and I ...READ MORE

Nov 30, 2022 in Database by Gustave

edited Mar 4 27 views
0 votes
0 answers

Get json object values and store as arrays

[ ['david','female','john','e6a33eee180b07e563d74fee8c2c66b8',1,1,'roger63'], ...READ MORE

Nov 16, 2022 in Database by Ashwini
• 5,430 points
1,745 views
0 votes
0 answers

Can PHP arrays hold items of different type?

The definition of an array in other ...READ MORE

Nov 16, 2022 in Database by Ashwini
• 5,430 points
982 views
0 votes
0 answers

nsert into a table, data returned from reserved command

Hi, I want to insert in a table, ...READ MORE

Oct 18, 2022 in Database by Edvaldo

edited Mar 4 32 views
0 votes
0 answers

Apache Hive - command Describle formatted table

About the describe formatted table command, is ...READ MORE

Oct 15, 2022 in Database by Edvaldo

edited Mar 4 32 views
0 votes
0 answers

Apache Hive - command Describle formatted table

About the describe formatted table command, is ...READ MORE

Oct 15, 2022 in Database by Edvaldo

edited Mar 4 36 views
0 votes
1 answer

ERROR 1064 (42000): You have an error in your SQL syntax;

It is varchar and not var_char CREATE DATABASE IF NOT EXISTS ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
9,508 views
0 votes
1 answer

Delete all the records

You can use this if you have ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
973 views
0 votes
1 answer

How can I create a unique constraint on my column (SQL Server 2008 R2)?

The "indexes and keys" dialogue, not the ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
1,148 views
0 votes
1 answer

Using ORDER BY and GROUP BY together

Correctly use the  group by: select l.* from table ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
837 views
0 votes
1 answer

IN Clause with NULL or IS NULL

An in statement will be parsed identically to field=val1 or ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
844 views
0 votes
1 answer

What is the difference between a primary key and a surrogate key?

The unique key in your database that ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
8,338 views
0 votes
1 answer

How do I obtain a Query Execution Plan in SQL Server?

There are several ways to get an ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
1,688 views
0 votes
1 answer

How to retrieve the current version of a MySQL database management system (DBMS)?

Many responses advise using mysql —version. But ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
854 views
0 votes
1 answer

How do I do multiple CASE WHEN conditions using SQL Server 2008?

There are three formats of the case expression. ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
2,434 views
0 votes
1 answer

java.sql.SQLException: Column count doesn't match value count at row 1

I think PreparedStatement would be a better choice. I ...READ MORE

Sep 20, 2022 in Database by narikkadan
• 63,600 points
2,546 views
0 votes
1 answer

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

Your table dbo.Sup Item Cat refers to ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
9,226 views
0 votes
1 answer

Escape Character in SQL Server

You can escape quotation like this: select 'it''s ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
1,260 views
0 votes
1 answer

Function to Calculate Median in SQL Server

Use a simple-ish median calculation for a ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
1,732 views
0 votes
1 answer

Highest Salary in each department

SELECT DeptID, MAX(Salary) FROM EmpDetails GROUP BY ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
2,381 views
0 votes
1 answer

SQL Server: IF EXISTS ; ELSE

Try this: update b set code = ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
4,251 views
0 votes
1 answer

Best way to do nested case statement logic in SQL Server

Try some sort of COALESCE trick: SELECT COALESCE( ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
7,964 views
0 votes
1 answer

How can I set an SQL Server connection string?

.NET DataProvider -- Standard Connection with username ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
817 views
0 votes
1 answer

What does SELECT COUNT(1) from table_name on any database table mean

An expression to be tested for each ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
926 views
0 votes
1 answer

How to find third or nᵗʰ maximum salary from salary table?

Use ROW_NUMBER(if you want a single) or DENSE_RANK(for all ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
1,293 views
0 votes
1 answer

How to check SQL Server version

Connect to the instance of SQL Server, ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,600 points
1,104 views
0 votes
1 answer

Is there a combination of "LIKE" and "IN" in SQL?

There is no LIKE & IN combination ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
5,003 views
0 votes
1 answer

How to format datetime in SQL SERVER

In SQL Server 2012 and up you ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
1,200 views
0 votes
1 answer

How to upsert (update or insert) in SQL Server 2005

Try to check for existence: IF NOT EXISTS ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
822 views
0 votes
1 answer

How to find top three highest salary in emp table in oracle?

Use this: SELECT *FROM ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
10,308 views
0 votes
1 answer

Why do I need to configure the SQL dialect of a data source?

Dialect is defined as "a language's variety." ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
1,529 views
0 votes
1 answer

SQL like search string starts with

SELECT * from games WHERE (lower(title) LIKE ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
4,327 views
0 votes
1 answer

Not equal <> != operator on NULL

Standard SQL-92 is represented by >; its ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
1,007 views
0 votes
1 answer

Multiple SQL Joins error in W3Schools Tryit Editor

I'm ruining this query on w3school even ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
2,233 views
0 votes
1 answer

Oracle PL/SQL - ORA-01403 "No data found" when using "SELECT INTO"

Just populate the field directly, using ordering ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
6,495 views
0 votes
1 answer

SQL Server: Multiple table joins with a WHERE clause

It matters whether you place the filter ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
1,176 views
0 votes
1 answer

SQL Server: Extract Table Meta-Data (description, fields and their data types)

Unfortunately, you have to utilize sysobjects/syscolumns to ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,600 points
971 views
0 votes
1 answer

org.hibernate.exception.SQLGrammarException: could not extract ResultSet

In the stacktrace, there is a line ...READ MORE

Sep 17, 2022 in Database by narikkadan
• 63,600 points
6,367 views