Most voted questions in Database

+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,080 points
403 views
+1 vote
1 answer

How to migrate a PostgreSQL database into a SQLServer one?

Hello @kartik, The easier way to accomplish this. First ...READ MORE

May 13, 2020 in Database by Niroj
• 82,720 points
239 views
+1 vote
0 answers

What are the advantages of SQL? [closed]

Dec 28, 2019 in Database by Yuth
• 130 points

closed Dec 30, 2019 by Kalgi 612 views
+1 vote
1 answer

Do I need to mention primary key for each table?

Hi Pritha, First, there is no hard and ...READ MORE

Jul 4, 2019 in Database by sampriti
• 1,120 points
308 views
+1 vote
1 answer

How can I reset my auto_increment column in MYSQL?

Hi Pratim, I understand your issue. I think you ...READ MORE

Jul 2, 2019 in Database by sampriti
• 1,120 points
315 views
+1 vote
1 answer

What are the features of MySQL?

The features of MySQL are as follows: Ease ...READ MORE

Dec 12, 2018 in Database by DataKing99
• 8,240 points
3,812 views
+1 vote
1 answer

What are the data types in MySQL?

The Data Types of MySQL are as ...READ MORE

Dec 12, 2018 in Database by DataKing99
• 8,240 points
1,631 views
+1 vote
1 answer

What is the AND operator?

The AND operator is used to filter ...READ MORE

Dec 1, 2018 in Database by Sahiti
• 6,360 points
278 views
+1 vote
2 answers

List few commands of DDL, DML, and DCL.

The list of commands is as follows:  Data ...READ MORE

Nov 12, 2018 in Database by Sahiti
• 6,360 points
75,237 views
+1 vote
3 answers

Difference between SQL and PL/SQL

In Oracle database administration, there are two ...READ MORE

Sep 25, 2019 in Database by gautham
701 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,240 points
10,750 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,720 points
1,190 views
+1 vote
1 answer

Cursor and Its Types

The cursor is a temporary work area ...READ MORE

Aug 9, 2018 in Database by CodingByHeart77
• 3,720 points
283 views
0 votes
0 answers

ORA-00904: invalid identifier

I am getting this error while doing ...READ MORE

May 20 in Database by Kichu
• 19,040 points
42 views
0 votes
0 answers

phpMyAdmin - Error > Incorrect format parameter?

I used this command: select database > ...READ MORE

May 19 in Database by Kichu
• 19,040 points
89 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 in Database by Kichu
• 19,040 points
161 views
0 votes
1 answer

Disable Sorting in excel

To quickly sort, select the Sort A ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
46 views
0 votes
1 answer

Excel VBA run-time error 1004 : Application-defined or object-defined error

Maybe your code is on Sheet 1, ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
227 views
0 votes
1 answer

Excel data to table on Dashing Dashboard?

It contains a feature named "Download." The ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
45 views
0 votes
1 answer

Convert Number to Words in Indian currency format with paise value

Use this code and check  <?php /** ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
576 views
0 votes
1 answer

Strange and Incorrect Excel Formulas Result?

Because the value in cell B1 may ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
26 views
0 votes
1 answer

is there a shortcut to open filter>contains box in excel?

The shortcut for opening the filter drop-down ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
28 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 in Database by gaurav
• 12,980 points
126 views
0 votes
1 answer

Converting Excel Date Serial Number to Date using Javascript

Please do try this : function ExcelDateToJSDate(serial) { ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
81 views
0 votes
1 answer

Excel Remove Decimal Places

INT function: Remove digits after decimal in ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
31 views
0 votes
1 answer

how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in MS Excel

First, pick the cells that contain dates, ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
122 views
0 votes
0 answers

How to add Indian Rupee Currency symbol in Google Spreadsheet

I need to add Indian Rupee Currency ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
25 views
0 votes
0 answers

Unprotect workbook without password

I have a popular VBA code to ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
24 views
0 votes
0 answers

EXCEL - How to create a custom cell format for an Australian phone number: xxxx-xxx-xxx

Australian mobile phone (cell phone) and land ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
45 views
0 votes
0 answers

Convert a vertical data in a excel sheet with one header

I have a problem converting a long ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
15 views
0 votes
0 answers

Datatables export Excel

I'm exporting the datatables in csv. And ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
71 views
0 votes
0 answers

Excel formula for reverse percentage calculation

I have a calculation which I am ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
20 views
0 votes
0 answers

Why should I use the DIM statement in VBA or Excel?

So there is a question on what DIM is, but I ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
14 views
0 votes
0 answers

How do I merge two rows in Excel?

Hi I'm not even sure if this ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
21 views
0 votes
0 answers

Excel - Find how many cells are in a range

For each cell in the column I ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
19 views
0 votes
0 answers

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
15 views
0 votes
1 answer

How to run a SQL query on an Excel table?

On Excel tables, how to construct and ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
45 views
0 votes
1 answer

Unable to compress excel file (XLSX or XLS) using java

Because the formats with a 'x' at ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
161 views
0 votes
1 answer

Vlookup Formula in Excel VBA

The VLOOKUP function can be used in ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
37 views
0 votes
1 answer

VBA Excel - Replace Enter key with Alt+ Enter

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

Apr 11 in Database by gaurav
• 12,980 points
48 views
0 votes
1 answer

Excel - Create item list from table values

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

Apr 11 in Database by gaurav
• 12,980 points
30 views
0 votes
1 answer

Use python extract images from Excel sheets

I found a solution # installing the modules pip3 ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
515 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 in Database by gaurav
• 12,980 points
18 views
0 votes
1 answer

Excel sort function to "skip" 1st row

Select the column range you will sort ...READ MORE

Apr 11 in Database by gaurav
• 12,980 points
30 views
0 votes
0 answers

Make sentence from data in cells in Excel

I have a form with three cells ...READ MORE

Apr 6 in Database by Edureka
• 13,640 points
27 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 in Database by gaurav
• 12,980 points
32 views
0 votes
1 answer

How to open a password protected excel file using python?

I recently came upon a Python package ...READ MORE

Apr 6 in Database by gaurav
• 12,980 points
754 views
0 votes
1 answer

How to calculate student pass percentage in excel

Percentage formula in Excel In cell D2, type ...READ MORE

Apr 6 in Database by gaurav
• 12,980 points
26 views
0 votes
1 answer

Maximum number of rows of CSV data in excel sheet

The maximum number of characters per cell ...READ MORE

Apr 6 in Database by gaurav
• 12,980 points
386 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 in Database by gaurav
• 12,980 points
21 views