Most viewed questions in Database

0 votes
1 answer

EXCEL: How to automatically add serial number in Excel Table using formula that is immune to filtering / sorting?

That's a great question, and it's a ...READ MORE

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

How will I get all the rows from my table where name starts with 's' and ending with 'I'?

Hi Santanu, I understand your problem, You can try ...READ MORE

May 28, 2019 in Database by sampriti
 • 1,120 points • 2,127 views
0 votes
1 answer

Excel formula get value just greater than an other

We can use the Search function in ...READ MORE

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

How to Execute SQL Server Stored Procedure in SQL Developer?

You don't need EXEC clause. Simply use: proc_name ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 63,600 points • 2,118 views
0 votes
1 answer

What is the Oracle PL/SQL "--+rule"?

The answer is in the material you ...READ MORE

Feb 23, 2022 in Database by Neha
 • 9,020 points • 2,105 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,000 points • 2,100 views
0 votes
1 answer

Excel - Create item list from table values

What is Data Validation, and how does ...READ MORE

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

how to Convert EST time to IST time in excel?

Use the following calculation since Indian Standard ...READ MORE

Mar 25, 2022 in Database by gaurav
 • 23,260 points • 2,082 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,690 points • 2,077 views
0 votes
1 answer

[Excel][VBA] How to draw a line in a graph?

Sub MakeChart() Dim x(20) ...READ MORE

Mar 24, 2022 in Database by gaurav
 • 23,260 points • 2,072 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,000 points • 2,062 views
0 votes
0 answers

Select Rows with id having even number

I'm passing a straightforward query that looks ...READ MORE

Aug 21, 2022 in Database by Kithuzzz
 • 38,000 points • 2,062 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,690 points • 2,062 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,000 points • 2,057 views
0 votes
1 answer

Install DB2 on Ubuntu

Hey @Dipti, follow these steps to install ...READ MORE

Mar 20, 2019 in Database by Kanika
 • 2,054 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
 • 2,049 views
0 votes
1 answer

How can I import an Excel file into SQL Server?

You can use OPENROWSET to import an Excel file ...READ MORE

Sep 15, 2022 in Database by narikkadan
 • 63,600 points • 2,044 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 • 2,040 views
0 votes
0 answers

Convert Month Number to Month Name Function in SQL

I have the months 1, 2, 3, ...READ MORE

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

Table design approach Hbase

Tall-Narrow and Flat-Wide are the two HBase ...READ MORE

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

LEFT JOIN vs. LEFT OUTER JOIN in SQL Server

At the top level there are mainly ...READ MORE

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

Accessing connection from different class in Java / MySQL?

You should just instantiate DoComms with every ...READ MORE

Nov 14, 2018 in Database by nirvana
 • 3,130 points • 1,969 views
0 votes
0 answers

Getting java.sql.SQLException: Operation not allowed after ResultSet closed

The following code throws an exception when ...READ MORE

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

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102

I'm getting the SQLSTATE[HY093] error: Line 102 ...READ MORE

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

What is subquery in SQL?

A subquery is a query inside another ...READ MORE

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

Shortcut for changing the editor font size in Oracle SQL Developer

Is there a shortcut in Oracle SQL ...READ MORE

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

Getting only Month and Year from SQL DATE

In addition to the advice already given, ...READ MORE

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

How can we perform common set operations (union, intersection, minus) in MS Excel?

The MATCH function can be used as ...READ MORE

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

Change default 'delimiters' in excel

Select a non-empty cell. Do Data -> Text ...READ MORE

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

Which one is suitable for real time big database- Primary Key or Unique Index?

What is a unique index? A unique index ...READ MORE

Oct 12, 2018 in Database by Frankie
 • 9,830 points • 1,882 views
0 votes
0 answers

SQL Server PRINT SELECT (Print a select query result)?

I want to print a particular value; ...READ MORE

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

Different types of a subquery

There are two types of subquery namely, ...READ MORE

Oct 18, 2018 in Database by DataKing99
 • 8,250 points • 1,874 views
0 votes
1 answer

What is the definition of cardinality in SQL?

Cardinality is defined as the "number of ...READ MORE

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

Excel indirect reference produces a #ref error

The formula =SUM(B2,C2,D2) is used in column ...READ MORE

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

Easy way to export multiple data.frame to multiple Excel worksheets

To export numerous data frames from R ...READ MORE

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

EXCEL: How to automatically add serial number in Excel Table using formula that is immune to filtering / sorting?

These techniques can add a running column ...READ MORE

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

Dynamic Drop Down lists using ajax, sql and php

I have a code that is effective. ...READ MORE

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

Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

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

How to cache data in a MVC application?

Reference the System.Web dll in your model ...READ MORE

Oct 25, 2018 in Database by Frankie
 • 9,830 points • 1,841 views
0 votes
1 answer

Difference between clustered and non clustered index in SQL

The differences between the clustered and non ...READ MORE

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

Unable to uninstall MongoDB

Try apt-get --reinstall install mongodb This will pretend that ...READ MORE

Mar 15, 2019 in Database by Jobin
 • 1,826 views
0 votes
1 answer

How do I install MariaDB on Windows?

Hwy @Mike, install the latest stable version ...READ MORE

Mar 22, 2019 in Database by Nitin
 • 1,819 views
0 votes
1 answer

Delete row in HBase

In Hbase, whatever you write will be ...READ MORE

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

Multiple SQL Joins error in W3Schools Tryit Editor

I'm ruining this query on w3school even ...READ MORE

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

SQL Error: ORA-00913: too many values

The table name, column names, datatype, and ...READ MORE

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

Can't connect to mysql server in workbench. Kindly please support. username: root & Password: 1234 (i gave)

Hey, @Arivukani, You can see once thing, the solution ...READ MORE

Mar 30, 2020 in Database by Gitika
 • 65,770 points • 1,789 views
0 votes
0 answers

Get the last inserted row ID (with SQL statement)

When you add a new record to ...READ MORE

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

ACID property in a database

ACID stands for Atomicity, Consistency, Isolation, Durability. It ...READ MORE

Oct 8, 2018 in Database by Sahiti
 • 6,370 points • 1,766 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.