Most viewed questions in Database

0 votes
1 answer

Please name some online websites to compile and run PL/SQL?

For executing Oracle SQL queries and PL/SQL ...READ MORE

Feb 11, 2022 in Database by Neha
 • 9,020 points • 1,686 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,685 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,684 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,684 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,684 views
0 votes
1 answer

Verify MariaDB is installed

Once you're done installing, execute the following ...READ MORE

Mar 18, 2019 in Database by Kiran
 • 1,683 views
0 votes
0 answers

HAVING without GROUP BY

Does the following make sense in terms ...READ MORE

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

How to refresh Excel file every second?

Data should be refreshed at regular intervals. Select ...READ MORE

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

Unable to connect to SQL Express "Error: 26-Error Locating Server/Instance Specified)

I am at a loss with one ...READ MORE

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

What are stored procedures?

The stored procedure is a collection of ...READ MORE

Aug 23, 2018 in Database by CodingByHeart77
 • 3,750 points • 1,666 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,660 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,652 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,648 views
0 votes
1 answer

SQL Switch/Case in 'where' clause

Without a case statement: SELECT column1, ...READ MORE

Feb 7, 2022 in Database by Vaani
 • 7,070 points • 1,631 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 • 1,629 views
0 votes
0 answers

How to update Identity Column in SQL Server?

With 200 records currently, I want to ...READ MORE

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

Query to list number of records in each table in a database

Use the below code to list number of ...READ MORE

Oct 11, 2019 in Database by Omaiz
 • 560 points • 1,620 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,613 views
0 votes
1 answer

How to count distinct values in Excel

Use functions to count the number of ...READ MORE

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

SQL Server: Invalid Column Name

I am in the process of changing ...READ MORE

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

SQL Server Cannot perform an aggregate function on an expression containing an aggregate or a subquery

Error: Cannot perform an aggregate function on an ...READ MORE

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

What does the "@" symbol do in SQL?

The @CustID denotes a parameter for which ...READ MORE

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

Debugging tools: PIG

explain utility is helpful for Hadoop developers ...READ MORE

Sep 12, 2018 in Database by kurt_cobain
 • 9,350 points • 1,586 views
0 votes
1 answer

What is MSLAB and LZO?

MSLAB stands for Memstore-Local Allocation Buffer. Lempel-Ziv-Oberhumer (LZO) ...READ MORE

Jul 10, 2018 in Database by Data_Nerd
 • 2,390 points • 1,582 views
0 votes
1 answer

How can I check my all existing table in MySQL database?

Hi Pratik, I understand your problem regarding this ...READ MORE

Jul 1, 2019 in Database by sampriti
 • 1,120 points • 1,581 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,580 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,579 views
0 votes
1 answer

Excel - AVERAGEIFS with OR conditions?

The AVERAGEIFS function in Excel determines the ...READ MORE

Mar 31, 2022 in Database by gaurav
 • 23,260 points • 1,578 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,600 points • 1,573 views
0 votes
1 answer

LIMIT 10..20 in SQL Server

The LIMIT clause is not included in ...READ MORE

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

excel Copy shapes from one worksheet to another

This will copy all the shapes from Sheet1 to Sheet2: Sub ...READ MORE

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

How to install MySQL in Ubuntu?

To install MySQL on ubuntu you have ...READ MORE

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

SQL JOIN - WHERE clause vs. ON clause

They are not the same thing. Consider these ...READ MORE

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

How do I view the Explain Plan in Oracle Sql developer?

I want to check the query execution ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,000 points • 1,567 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
 • 1,567 views
0 votes
1 answer

How Can I use "Date" Datatype in sql server?

There's problem in all of them and ...READ MORE

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

Can you explain what is the difference between UNION and Join?

Hi Sahana,  I got your doubt, Checkout these ...READ MORE

May 30, 2019 in Database by sampriti
 • 1,120 points • 1,561 views
0 votes
1 answer

How can I define a composite primary key in SQL?

A primary key is unique and it ...READ MORE

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

Insert multiple rows into single column

I am having problems adding numerous data ...READ MORE

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

Number of rows affected by an UPDATE in PL/SQL

You can try using the following query: SELECT ...READ MORE

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

VBA Excel - Replace Enter key with Alt+ Enter

I created Button1 and assigned the Enter ...READ MORE

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

Add Auto-Increment ID to existing table?

Make sure none of your other columns ...READ MORE

Feb 8, 2023 in Database by JPC
edited Mar 5 • 1,544 views
0 votes
0 answers

UPDATE and REPLACE part of a string

A table I have has two columns: ...READ MORE

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

Excel: Highlighting duplicates with exact matches

To enter the Advanced Filter dialogue box, ...READ MORE

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

How to type Unicode currency character in Visual Basic Editor

VBA editor is not Unicode. In order to ...READ MORE

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

SQL Update from One Table to Another Based on a ID Match

Account and credit card numbers are stored ...READ MORE

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

How to refresh Excel file every second?

Data should be refreshed at regular intervals. Select ...READ MORE

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

How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access

I use the following code in Python ...READ MORE

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

SQL server invalid object name - but tables are listed in SSMS tables list

I'm trying to develop a stored procedure ...READ MORE

Sep 3, 2022 in Database by Kithuzzz
 • 38,000 points • 1,522 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.