Most answered questions in Database

0 votes
3 answers

MySQL "Could not create connection to database serve" error

Pls check that you have MySQL server ...READ MORE

Jul 3, 2020 in Database by anonymous
 • 29,276 views
+2 votes
3 answers

Difference between SQL and PL/SQL

In Oracle database administration, there are two ...READ MORE

Sep 25, 2019 in Database by gautham
 • 1,288 views
0 votes
3 answers

What is Phantom deadlock?

To understand phantom deadlock, you need an ...READ MORE

Feb 13, 2019 in Database by Ravi kumar
 • 8,712 views
0 votes
2 answers

Case in Select Statement

I think these could be helpful for ...READ MORE

Feb 4, 2022 in Database by Neha
 • 9,060 points • 388 views
0 votes
2 answers

How to send data to my database from html and css Contact Us Form?

Hello @Sign, It is simple to create contact ...READ MORE

Aug 4, 2020 in Database by Niroj
 • 82,880 points • 35,038 views
0 votes
2 answers

How to select the nth row in a SQL database table?

SELECT * FROM ( SELECT ID, NAME, ROW_NUMBER() ...READ MORE

Apr 23, 2020 in Database by anand
 • 140 points • 25,061 views
0 votes
2 answers

Why is SELECT * table_name; is considered harmful?

Hi. Adding to @Tina's answer, there is ...READ MORE

Sep 23, 2019 in Database by Raghu
 • 824 views
0 votes
2 answers

Install postgreSQL on Ubuntu

Follow the below commands to install PostgreSQL (PSQL) ...READ MORE

Nov 12, 2020 in Database by Prachi
 • 140 points • 936 views
0 votes
2 answers

What is PostgreSQL?

HI... PostgreSQL is one of the top databases ...READ MORE

Oct 22, 2020 in Database by SRI
edited Oct 22, 2020 by Gitika • 1,003 views
0 votes
2 answers

How to create a shared database for users for different systems to connect to a single database in another system.?

Like Omkar said, while presenting your project ...READ MORE

Mar 18, 2019 in Database by Vardhan
 • 13,190 points • 4,132 views
+1 vote
2 answers

List few commands of DDL, DML, and DCL.

The list of commands is as follows:  Data ...READ MORE

Nov 12, 2018 in Database by Sahiti
 • 6,370 points • 119,362 views
0 votes
2 answers

Advantages and Disadvantages of Stored Procedure

https://www.quora.com/What-are-the-advantages-of-using-an-SQL-store ...READ MORE

Apr 29, 2019 in Database by anonymous
 • 19,755 views
0 votes
2 answers

Write a SQL query to find the names of employees that begin with ‘S’

Select ename From emp Where ename like"s%"; READ MORE

Oct 7, 2021 in Database by anonymous
 • 25,461 views
0 votes
2 answers

What are the ways to get the count of records in a table

With the help of the SQL count ...READ MORE

Aug 20, 2020 in Database by Okugbe
 • 280 points • 3,601 views
0 votes
2 answers

Different types of SQL Joins

There are 4 types of joins in ...READ MORE

Dec 9, 2020 in Database by bhavani
 • 1,782 views
0 votes
2 answers

Difference between primary key a composite key

candidate  key: It is the collection of ...READ MORE

Oct 14, 2020 in Database by anonymous
 • 30,467 views
0 votes
2 answers

Types of relationships in Database

There are 3 types of relationships in ...READ MORE

Aug 17, 2018 in Database by zombie
 • 3,790 points • 2,305 views
0 votes
2 answers

SQL vs NoSQL

Well, it depends on what you are ...READ MORE

Aug 11, 2018 in Database by slayer
 • 29,350 points • 874 views
0 votes
2 answers

Database Lock and its types.

Hello Dataking99, A database lock is used to ...READ MORE

Apr 20, 2020 in Database by Niroj
 • 82,880 points • 17,239 views
0 votes
2 answers

Durable Writes in Cassandra

When Cassandra write: 1. memtable (in memory) 2. commit ...READ MORE

Nov 25, 2018 in Database by Amit
 • 180 points • 6,855 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,420 points • 8,452 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,420 points • 601 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,420 points • 620 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,420 points • 548 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,420 points • 458 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,420 points • 6,658 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,420 points • 867 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,420 points • 406 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,420 points • 1,683 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,420 points • 1,694 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,420 points • 7,371 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,420 points • 746 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,420 points • 1,011 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,420 points • 1,806 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,420 points • 3,071 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,420 points • 6,540 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,420 points • 486 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,420 points • 436 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,420 points • 727 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,420 points • 489 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,420 points • 3,335 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,420 points • 592 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,420 points • 465 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,420 points • 7,207 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,420 points • 886 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,420 points • 3,490 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,420 points • 552 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,420 points • 1,214 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,420 points • 4,223 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,420 points • 592 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.