Trending questions in Database

0 votes
1 answer

SQL Server CASE .. WHEN .. IN statement

Two forms of CASE statements are getting ...READ MORE

Feb 8, 2022 in Database by Vaani
 • 7,070 points • 764 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 • 636 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,020 points • 894 views
0 votes
1 answer

How do I UPDATE from a SELECT in SQL Server?

MERGE INTO YourTable T USING ...READ MORE

Feb 3, 2022 in Database by Vaani
 • 7,070 points • 916 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 • 585 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 • 779 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 • 617 views
0 votes
0 answers

How to add constraints in SQL?

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

how to use sql server management studio

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

what does sql stand for?

Feb 1, 2022 in Database by Neha
 • 9,020 points • 283 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
 • 27,691 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 1 day ago • 22,446 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
 • 31,529 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 • 26,932 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
 • 30,236 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,840 points • 20,934 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 • 16,710 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 2 days ago • 6 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,840 points • 18,573 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 2 days ago • 5 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,840 points • 7,011 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 2 days ago • 9 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 2 days ago • 5 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 2 days ago • 4 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 • 3,657 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,840 points • 916 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
 • 961 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,082 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 • 8,431 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,840 points • 7,050 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,770 points • 1,520 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,840 points • 1,446 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 • 825 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,840 points • 5,489 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,840 points • 18,717 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,840 points • 2,498 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,840 points • 1,676 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,840 points • 4,168 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,840 points • 1,038 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 • 12,883 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 • 29,919 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,840 points • 3,202 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,840 points • 2,784 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,840 points • 2,751 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,840 points • 2,626 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 1 day ago • 5,992 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 • 922 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,770 points • 1,125 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,840 points • 2,245 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 • 27,367 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.