Most viewed questions in Database

0 votes
0 answers

Loop in stored procedure in SQL server

Writing a stored procedure that calls another ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,000 points • 1,750 views
0 votes
0 answers

Why did a network-related or instance-specific error occur while establishing a connection to SQL Server?

I'm incredibly annoyed. Everything is wonderful with ...READ MORE

Sep 5, 2022 in Database by narikkadan
 • 63,600 points • 1,727 views
0 votes
0 answers

SQLite in Android How to update a specific row

For a time now, I've been attempting ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 38,000 points • 1,723 views
0 votes
1 answer

Number Formatting to 10K 5M, etc in Excel 2016

In the format of a user-defined number [>=1000000]0,,"M";[>=1000]0,"K";0 The ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,690 points • 1,717 views
0 votes
0 answers

Select rows with same id but different value in another column

I've read numerous threads and tried for ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
 • 38,000 points • 1,716 views
0 votes
1 answer

Python Stress Test

Cassandra comes with a popular utility called ...READ MORE

Jun 29, 2018 in Database by Data_Nerd
 • 2,390 points • 1,713 views
0 votes
0 answers

How to convert date into timestamp in SQL query?

I'm attempting to move data from the ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 1,705 views
0 votes
1 answer

How do I perform an IF THEN statement in an SQL SELECT?

The CASE statement is the closest to IF in ...READ MORE

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

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

I've been attempting to solve a significant ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 1,678 views
0 votes
0 answers

Access denied for user 'root@localhost' (using password:NO)

I wanted to run WordPress and it ...READ MORE

May 8, 2022 in Database by Kichu
 • 19,040 points • 1,676 views
0 votes
1 answer

What datatype should be used for storing phone numbers in SQL Server 2005?

Does this include: International numbers? Extensions? Other information besides the ...READ MORE

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

Insert into ... values ( SELECT ... FROM ... )

Try: INSERT INTO tableA ( column_1 ) SELECT ...READ MORE

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

two back slash in SQL procedure with Regular expression

It's the escape prefix in regular expressions: ...READ MORE

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

How to deal with "Microsoft Excel is waiting for another application to complete an OLE action"

The first step in troubleshooting is to ...READ MORE

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

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 1,655 views
0 votes
1 answer

Difference between Inner Join & Outer Join

The difference is as follows: INNER JOIN: Returns all those ...READ MORE

Sep 7, 2018 in Database by DataKing99
 • 8,250 points • 1,649 views
0 votes
1 answer

Calculate a Running Total in SQL Server

The problem is that the SQL Server ...READ MORE

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

IF excel formula like =IF(C6>=70,"Pass","Fail") throws error

Using Excel's IF & AND function Assume ...READ MORE

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

Types of tables in MySQL

MyISAM is the default table that is ...READ MORE

Aug 21, 2018 in Database by CodingByHeart77
 • 3,750 points • 1,633 views
0 votes
0 answers

How to find sum of multiple columns in a table in SQL Server 2005?

I have a table Emp which has these rows: Emp_cd ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 1,632 views
0 votes
0 answers

Merging Two excel files as two sheets in one workbook in java

I have two xlsx files at folder ...READ MORE

Mar 10, 2022 in Database by Edureka
 • 13,690 points • 1,621 views
0 votes
1 answer

STUFF and REPLACE function in SQL

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

Sep 28, 2018 in Database by DataKing99
 • 8,250 points • 1,619 views
0 votes
1 answer

Convert Rows to columns using 'Pivot' in SQL Server

You can use the PIVOT function to ...READ MORE

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

How to convert SQL Server's timestamp column to datetime format

Is there a simple way to convert ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 1,613 views
0 votes
1 answer

Deleting duplicate rows in Excel using Epplus

Versions 3.5 and 2.0 of the NET ...READ MORE

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

How to calculate age (in years) based on Date of Birth and getDate()

Following can be a solution to your ...READ MORE

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

If Cell Starts with Text String... Formula

I have formula that checks if the ...READ MORE

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

Key Components of HBase

Zookeeper: It does the co-ordination work between client ...READ MORE

Jul 24, 2018 in Database by kurt_cobain
 • 9,350 points • 1,578 views
+2 votes
1 answer

How to export data from MySql to a CSV file?

If you are using MySql workbench then ...READ MORE

Jan 4, 2019 in Database by Priyaj
 • 58,020 points • 1,576 views
0 votes
1 answer

SQL keys, MUL vs PRI vs UNI

It denotes that the field is (a ...READ MORE

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

Hcatalog in HIVE

HCatalog supports reading and writing files in ...READ MORE

Aug 30, 2018 in Database by kurt_cobain
 • 9,350 points • 1,553 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,549 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,548 views
0 votes
0 answers

Android Studio, how to retrieve data from Sqlite database and display it into textview?

I built a SQLite Database and added ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,000 points • 1,518 views
0 votes
0 answers

Rounding off to two decimal places in SQL

Minutes must be converted to hours and ...READ MORE

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

Algorithm used in Excel Fuzzy Lookup

There are two data sets that must ...READ MORE

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

How to install Oracle DB on Windows?

Installing Oracle DB is pretty easy wrt other ...READ MORE

Feb 28, 2019 in Database by Priyaj
 • 58,020 points • 1,508 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,502 views
0 votes
1 answer

Deleting duplicate rows in Excel using Epplus

You need to re-think this… the while ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 1,499 views
0 votes
1 answer

SQL Server replaces LEFT JOIN for LEFT OUTER JOIN in view query

You are getting the joins confused and ...READ MORE

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

PL/MySQL does it exist?

Despite the fact that MySQL and PL/SQL ...READ MORE

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

Do I need to add primary key in each and every table?

Hi Shraddha, You have a doubt to add ...READ MORE

May 29, 2019 in Database by sampriti
 • 1,120 points • 1,494 views
0 votes
0 answers

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm attempting to insert the number 1 ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
 • 38,000 points • 1,482 views
0 votes
1 answer

Standalone Mode in Hbase

It is a default mode of HBase. ...READ MORE

Jul 11, 2018 in Database by kurt_cobain
 • 9,350 points • 1,480 views
0 votes
1 answer

Different Types Of Index

There are three types of index namely: Unique ...READ MORE

Oct 11, 2018 in Database by DataKing99
 • 8,250 points • 1,477 views
0 votes
0 answers

Sql Server 'Saving changes is not permitted' error ► Prevent saving changes that require table re-creation

If I try to change a column ...READ MORE

Sep 4, 2022 in Database by Kithuzzz
 • 38,000 points • 1,476 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,470 views
0 votes
1 answer

#NAME? error in Excel for VBA Function

Because you have a module with the ...READ MORE

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

Aggregate Functions in MySQL

The aggregate functions are as follows: MIN() Function This ...READ MORE

Nov 26, 2018 in Database by DataKing99
 • 8,250 points • 1,461 views
0 votes
0 answers

SQL Server database restore error: specified cast is not valid. (SqlManagerUI)

For my production website, SQL Server 2008 ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
 • 38,000 points • 1,454 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.