Trending questions in Database

0 votes
1 answer

SQL WITH clause example

Oracle introduced the SQL WITH clause in ...READ MORE

Feb 17, 2022 in Database by Neha
 • 9,020 points • 1,148 views
0 votes
1 answer

Should I use != or <> for not equal in T-SQL?

Most of the existing databases support != Databases that ...READ MORE

Feb 14, 2022 in Database by Vaani
 • 7,070 points • 1,249 views
0 votes
1 answer

NOT IN vs NOT EXISTS

In my opinion, the most efficient way ...READ MORE

Feb 11, 2022 in Database by Neha
 • 9,020 points • 1,336 views
0 votes
1 answer

What is an index in SQL?

An index is used to speed up ...READ MORE

Feb 3, 2022 in Database by Vaani
 • 7,070 points • 1,636 views
0 votes
1 answer

What do you mean by Clustered and Non-Clustered index?

The rows in a clustered index are ...READ MORE

Feb 10, 2022 in Database by Vaani
 • 7,070 points • 1,328 views
0 votes
0 answers

SQL: Display Full Name + Filter By Subject

Feb 22, 2022 in Database by Neha
 • 9,020 points • 754 views
0 votes
0 answers

How do I UPDATE from a SELECT in SQL Server?

INSERT INTO Table (col1, col2, col3) SELECT col1, ...READ MORE

Feb 4, 2022 in Database by Vaani
 • 7,070 points • 1,269 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
 • 30,213 views
0 votes
0 answers

How to add constraints in SQL?

Jan 31, 2022 in Database by Neha
 • 9,020 points • 991 views
0 votes
0 answers

how to use sql server management studio

Jan 31, 2022 in Database by Neha
 • 9,020 points • 979 views
0 votes
0 answers

what does sql stand for?

Feb 1, 2022 in Database by Neha
 • 9,020 points • 745 views
0 votes
1 answer

What do ‘Record’, ‘Field’ and ‘Table’ mean in terms of a database?

Record is the collection of fields, possibly ...READ MORE

Oct 6, 2021 in Database by Adebayo fikayo
edited Mar 5, 2025 • 25,470 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 • 29,028 views
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
 • 32,259 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
 • 32,858 views
0 votes
1 answer

Error:Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation.

Hello @kartik, You can resolve the issue by ...READ MORE

May 13, 2020 in Database by Niroj
 • 82,800 points • 22,491 views
+1 vote
1 answer

Difference between cross join and natural join

The cross join produces the cross product ...READ MORE

Oct 12, 2018 in Database by DataKing99
 • 8,250 points • 18,087 views
0 votes
0 answers

Getting "Pre-login Handshake error" while connecting the MySQL database to Power BI

I was about to start a Project ...READ MORE

Aug 16, 2021 in Database by Aditya
edited Mar 4, 2025 • 542 views
0 votes
1 answer

MySQL Error: : 'Access denied for user 'root'@'localhost'

Hello @kartik, I did this to set my ...READ MORE

May 4, 2020 in Database by Niroj
 • 82,800 points • 19,442 views
0 votes
1 answer

/opt/mssql/bin/mssql-conf: command not found in Ubuntu 20.04

Hello @netwell, You need to have at least 3.25 ...READ MORE

Oct 19, 2020 in Database by Niroj
 • 82,800 points • 8,303 views
0 votes
0 answers

Azure Data Engineer

I am looking for Azure Data Engineer ...READ MORE

Apr 19, 2021 in Database by Shiva Kumar
edited Mar 4, 2025 • 462 views
0 votes
0 answers

mongodb client not found error pls solve this error

 [pid 21047] [client 127.0.0.1:49804] PHP Parse error:  ...READ MORE

Mar 5, 2021 in Database by Soni
edited Mar 4, 2025 • 521 views
0 votes
0 answers

SQL Query help

Dear Team, I am trying to submit a ...READ MORE

Feb 20, 2021 in Database by anonymous
edited Mar 4, 2025 • 398 views
0 votes
0 answers

'NoneType' object has no attribute 'name'

in the models.py: name = models.CharField(max_length=50, db_index=True) gender = ...READ MORE

Jun 18, 2020 in Database by prince
 • 120 points
edited Jun 18, 2020 by Gitika • 4,572 views
0 votes
0 answers

"Network adaptor could not establish the connection" Error displayed

READ MORE

Jan 25, 2021 in Database by Boopathy
 • 370 points
edited Mar 4, 2025 • 439 views
0 votes
1 answer

Updating multiple records in this year with information held in previous year.

Hello, For your query you can refer this:https://www.plus2net.com/sql_tutorial/sql_update.php Hope ...READ MORE

Nov 9, 2020 in Database by Niroj
 • 82,800 points • 1,653 views
0 votes
0 answers

How to Secure Postgres in cilium like Cassanda.

I want help in writing  code in ...READ MORE

Oct 14, 2020 in Database by Aryan
 • 190 points • 1,980 views
0 votes
1 answer

How does Docker CLI connects with DB?

To connect Docker CLI with a Database, ...READ MORE

Oct 19, 2020 in Database by lyana
 • 1,607 views
0 votes
1 answer

ERROR 1006 (HY000): Can't create database 'test' (errno: 2) in mysql

Hi@akhtar, You have to change the permissions or ...READ MORE

Apr 14, 2020 in Database by MD
 • 95,460 points • 9,492 views
0 votes
1 answer

Error:Unable to instantiate default tuplizer [org.hibernate.tuple.entity.PojoEntityTuplizer]

Hii @kartik, I was also facing the same ...READ MORE

May 13, 2020 in Database by Niroj
 • 82,800 points • 7,893 views
0 votes
1 answer

error while Retrieving the subquery column in where condition to main query

Hello @Jyra, You should first pay attention to ...READ MORE

Sep 4, 2020 in Database by Niroj
 • 82,800 points • 2,453 views
0 votes
1 answer

RDS Replica Showing Storage full where all the configuration are same

Hey, @Syeda, If you expect an increase in ...READ MORE

Sep 8, 2020 in Database by Gitika
 • 65,730 points • 2,124 views
0 votes
1 answer

Error:Import SQL dump into PostgreSQL database

Hello, Here is the command you are looking ...READ MORE

May 4, 2020 in Database by Niroj
 • 82,800 points • 7,265 views
0 votes
0 answers

I need data from the the site of Justdial for my business. Anybody can tell from where do i get that?

Sep 1, 2020 in Database by Satish
 • 120 points • 1,459 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,800 points • 20,264 views
0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

Sep 11, 2018 in Database by CodingByHeart77
 • 3,750 points • 31,428 views
0 votes
1 answer

I need query based on Timestamp in sqlserver

Hello  vnk, To get some familiarity try creating and ...READ MORE

Jun 30, 2020 in Database by Niroj
 • 82,800 points • 3,392 views
0 votes
1 answer

How to set SSL to Domain name for MYSQL database

Hello @ Lakshminarayanan, Yes, It is possible to setup ...READ MORE

Jul 9, 2020 in Database by Niroj
 • 82,800 points • 2,451 views
0 votes
1 answer

How to schedule a job for sql query to run daily?

Hii, To schedule a job for sql query ...READ MORE

May 4, 2020 in Database by Niroj
 • 82,800 points • 4,940 views
0 votes
1 answer

My values in my codes aren't inserted into mySQL. I input 5 but it will show 0. Any ideas?

Hello, You can refer my corresponding sample web ...READ MORE

Jul 13, 2020 in Database by Niroj
 • 82,800 points • 1,767 views
0 votes
1 answer

Which is better database vs. flat files?

Difference between database and flat files are ...READ MORE

Oct 11, 2019 in Database by Omaiz
 • 560 points • 13,619 views
0 votes
1 answer

Why do we need Transaction in Hibernate for read-only operations?

Hello @kartik, It doesn't matter whether you only ...READ MORE

May 4, 2020 in Database by Niroj
 • 82,800 points • 4,023 views
0 votes
1 answer

Error Code: 2020. Lost connection to MySQL server during query

Hello @kartik, I got the same issue when ...READ MORE

May 4, 2020 in Database by Niroj
 • 82,800 points • 3,661 views
0 votes
1 answer

How do I kill all the processes in Mysql “show processlist”?

Hello kartik, Mass killing operation saves time. Do it ...READ MORE

May 4, 2020 in Database by Niroj
 • 82,800 points • 3,539 views
0 votes
1 answer

Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock)

Hii I was having the same problem and ...READ MORE

May 4, 2020 in Database by Niroj
 • 82,800 points • 3,538 views
0 votes
1 answer

Fetch first 5 characters of the string

Select StudentID, StudentName, Class, Division from Student order ...READ MORE

Jun 4, 2021 in Database by Dheeraj
edited Mar 5, 2025 • 6,820 views
0 votes
0 answers

Request for SQL Query

Hi team, How can I get a distinct ...READ MORE

Jun 8, 2020 in Database by vnk
 • 390 points • 1,717 views
0 votes
1 answer

Different subsets of SQL

The various subsets of SQL are as ...READ MORE

Sep 28, 2018 in Database by Sahiti
 • 6,370 points • 28,371 views
0 votes
1 answer

How to design data warehouse for support whole business?

Hi, @There, So here are a few steps ...READ MORE

Jun 1, 2020 in Database by Gitika
 • 65,730 points • 1,818 views
0 votes
1 answer

How can Mysql database sync between two databases?

Hii, Some simple rules you will have to ...READ MORE

May 4, 2020 in Database by Niroj
 • 82,800 points • 2,937 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.