Most viewed questions in Database

0 votes
1 answer

Converting a large XML file to Excel

Using the web URL, import an XML ...READ MORE

Mar 24, 2022 in Database by gaurav
• 23,260 points
2,314 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,880 points
2,311 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
2,288 views
0 votes
0 answers

Search text in stored procedure in SQL Server

I want to search all of my ...READ MORE

Aug 27, 2022 in Database by Kithuzzz
• 38,010 points
2,286 views
0 votes
0 answers

Not all parameters were used in the SQL statement (Python, MySQL)

Error: mysql.connector.errors.ProgrammingError: Not all parameters were used in ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
• 38,010 points
2,282 views
0 votes
1 answer

When is the functional dependency known as fully functional dependency?

The criteria of fully functional dependency, is ...READ MORE

Aug 10, 2018 in Database by DataKing99
• 8,240 points
2,277 views
0 votes
1 answer

Which SQL query is used to find Nth highest salary from a salary table

If you want to find nth Salary ...READ MORE

Feb 14, 2022 in Database by Vaani
• 7,020 points
2,275 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,241 views
0 votes
1 answer

Reading an Excel file in python using pandas

How to Use Pandas to Import an ...READ MORE

Mar 30, 2022 in Database by gaurav
• 23,260 points
2,234 views
0 votes
1 answer

Install DB2 on windows

Hey @Alok, follow these instructions: On the DB2 ...READ MORE

Mar 20, 2019 in Database by Kavyashri
2,219 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,880 points
2,202 views
0 votes
0 answers

Drop multiple tables in one shot in MySQL

How to drop multiple tables from one ...READ MORE

Aug 13, 2022 in Database by Kithuzzz
• 38,010 points
2,199 views
0 votes
1 answer

showing an error in a MySQL trigger

use this code: CREATE TRIGGER sample_trigger_msg ...READ MORE

Sep 27, 2019 in Database by Omaiz
• 560 points
2,182 views
0 votes
0 answers

How to ALTER multiple columns at once in SQL Server

ALTER the data types of several columns in ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
• 38,010 points
2,171 views
0 votes
1 answer

SQL Server: PARTITION BY vs GROUP BY

To understand the differences between GROUP BY ...READ MORE

Feb 9, 2022 in Database by Neha
• 9,060 points
2,167 views
0 votes
1 answer

Error: Cannot connect to the SQL Server on Ubuntu from SSMS - installing mssql on linux

Hey @Rajni, Verify if the server is running ...READ MORE

Mar 17, 2019 in Database by Anvit
2,163 views
0 votes
1 answer

Difference between STUFF & REPLACE function

STUFF Function: This function is used to ...READ MORE

Oct 10, 2018 in Database by CodingByHeart77
• 3,740 points
2,048 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

Sep 10, 2018 in Database by Sahiti
• 6,370 points
2,032 views
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

Dec 14, 2018 in Database by DataKing99
• 8,240 points
2,031 views
0 votes
0 answers

How to loop in excel without VBA or macros?

Is it possible to iterate (loop) a ...READ MORE

Mar 30, 2022 in Database by Edureka
• 13,670 points
2,016 views
0 votes
1 answer

Add a column with a default value to an existing table in SQL Server

Syntax: ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,420 points
1,998 views
0 votes
1 answer

Excel - count days in each month between two dates (both dates available)

Anyway, here's an alternative completeness approach based ...READ MORE

Apr 11, 2022 in Database by gaurav
• 23,260 points
1,986 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,959 views
0 votes
1 answer

SQL Server string to date conversion

Try this Cast('7/7/2011' as datetime) And Convert(DATETIME, '7/7/2011', 101) See CAST and ...READ MORE

Sep 16, 2022 in Database by narikkadan
• 63,420 points
1,941 views
0 votes
1 answer

Ways to improve query performance using Index hunting

Index hunting help in improving query performance ...READ MORE

Aug 29, 2018 in Database by CodingByHeart77
• 3,740 points
1,911 views
0 votes
1 answer

Database Repair Options in Cassandra

Anti Entropy: Anti-entropy Repair is a process of ...READ MORE

Jun 28, 2018 in Database by kurt_cobain
• 9,390 points
1,891 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,880 views
0 votes
0 answers

PDOException SQLSTATE[HY000] [2002] No such file or directory

My (very basic) site appears to have ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
• 38,010 points
1,866 views
0 votes
1 answer

List all the types of user-defined functions

There are three types of user-defined functions, ...READ MORE

Oct 29, 2018 in Database by Sahiti
• 6,370 points
1,862 views
0 votes
1 answer

How to translate a BDS excel-formula to XBBG API for Python

The parameters are improperly specified by you. ...READ MORE

Apr 1, 2022 in Database by gaurav
• 23,260 points
1,857 views
0 votes
1 answer

Merge excel files into a new excel file based on filename

How do I merge Excel files that ...READ MORE

Mar 31, 2022 in Database by gaurav
• 23,260 points
1,835 views
0 votes
0 answers

Modify an existing Excel file using Openpyxl in Python

I am basically trying to copy some ...READ MORE

Mar 25, 2022 in Database by Edureka
• 13,670 points
1,835 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,880 points
1,835 views
0 votes
1 answer

Is there a Boolean data type in Microsoft SQL Server like there is in MySQL?

The BIT datatype can be used to ...READ MORE

Sep 15, 2022 in Database by narikkadan
• 63,420 points
1,808 views
0 votes
1 answer

Split timestamp column into separate date and time columns in excel

Kutools for Excel allows you to split ...READ MORE

Apr 11, 2022 in Database by gaurav
• 23,260 points
1,808 views
0 votes
0 answers

SQL query to insert datetime in SQL Server

Using the SQL query below, I want ...READ MORE

Aug 29, 2022 in Database by Kithuzzz
• 38,010 points
1,795 views
+1 vote
1 answer

DELETE vs TRUNCATE vs DROP command

After the execution of ‘DELETE’ operation, COMMIT ...READ MORE

Aug 23, 2018 in Database by CodingByHeart77
• 3,740 points
1,776 views
0 votes
1 answer

Connection vs Query in Excel data model

There are various ways to construct and ...READ MORE

Apr 4, 2022 in Database by Edureka
• 13,670 points
1,766 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,764 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,880 points
1,764 views
0 votes
1 answer

Excel formula to remove comma, spaces, period and add a text

The steps to accomplish this are as ...READ MORE

Mar 15, 2022 in Database by gaurav
• 23,260 points
1,763 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,758 views
0 votes
1 answer

What is the best way to fetch data from table?

Hey Shraddha, I understand your doubts about fetching ...READ MORE

May 25, 2019 in Database by sampriti
• 1,120 points
1,750 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,743 views
0 votes
1 answer

Difference between numeric, float and decimal in SQL Server

use the float or real data types only if the precision provided by decimal (up ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 63,420 points
1,722 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,719 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24, 2022 in Database by Edureka
• 13,670 points
1,697 views
0 votes
1 answer

Excel COUNTIF with multiple criteria and both row and column

Count Cells Based On Text Value Using ...READ MORE

Mar 25, 2022 in Database by gaurav
• 23,260 points
1,694 views
0 votes
0 answers

Comparing Dates in Oracle SQL

I'm attempting to get it to show ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
• 38,010 points
1,690 views
0 votes
1 answer

What is checkpoint in Database?

Checkpoint declares a point before which all ...READ MORE

Sep 4, 2018 in Database by Sahiti
• 6,370 points
1,668 views