Most answered questions in Database

0 votes
1 answer

How to calculate percentage with a SQL statement

The following has passed my tests, and ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
6,607 views
0 votes
1 answer

What are projection and selection?

Projection means choosing which columns (or expressions) the query shall ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
8,364 views
0 votes
1 answer

Add primary key to existing table

You have to drop constraint and recreate ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 86,360 points
987 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
• 86,360 points
1,976 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
• 86,360 points
1,941 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
• 86,360 points
2,728 views
0 votes
1 answer

java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

The maximum-open-cursors error, also known as ORA-01000, ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 86,360 points

edited Jul 5, 2023 by Khan Sarfaraz 4,274 views
0 votes
1 answer

How to execute function in SQL Server 2008

The function appears not to be being ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 86,360 points
1,236 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
• 86,360 points
2,158 views
0 votes
1 answer

Difference between EXISTS and IN in SQL?

Although the exists keyword can be used ...READ MORE

Sep 11, 2022 in Database by narikkadan
• 86,360 points
1,177 views
0 votes
1 answer

SQL Server WITH statement

I'm going to guess because I don't ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
1,056 views
0 votes
1 answer

How to convert date to a format `mm/dd/yyyy`

My date of birth change READ MORE

Feb 23, 2023 in Database by anonymous

edited Mar 5 4,742 views
0 votes
1 answer

Use of contains() in sql server

The straightforward method is shown here. You ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
1,541 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
• 86,360 points
2,065 views
0 votes
1 answer

How can I use LTRIM/RTRIM to search and replace leading/trailing spaces?

Use LTRIM/RTRIM to eliminate spaces from the ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
1,617 views
0 votes
1 answer

Get list of databases from SQL Server

Execute: SELECT name FROM master.sys.databases I hope this helps ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
958 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
• 86,360 points
1,754 views
0 votes
1 answer

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

I saw the problem in the line ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
6,049 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,677 views
0 votes
1 answer

How do I run an sql query in php?

Try this: <?php $conn = new mysqli('localhost', 'jaydeep_mor', 'jaydeep_mor', ...READ MORE

Sep 10, 2022 in Database by narikkadan
• 86,360 points
1,167 views
0 votes
1 answer

Difference of two date time in sql server

Just a note of caution with DateDiff: ...READ MORE

Aug 27, 2022 in Database by narikkadan
• 86,360 points

edited Mar 5 886 views
0 votes
1 answer

Calculate time difference in minutes in SQL Server

SELECT  Diff = CASE DATEDIFF(HOUR, StartTime, EndTime)                     WHEN ...READ MORE

Oct 4, 2022 in Database by anonymous

edited Mar 5 1,552 views
0 votes
1 answer

How to retrieve data from sqlite database in android and display it in TextView

When a button is clicked, the database ...READ MORE

Aug 11, 2022 in Database by narikkadan
• 86,360 points

edited Mar 5 5,470 views
0 votes
1 answer

Disable Sorting in excel

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

Apr 11, 2022 in Database by gaurav
• 23,580 points
1,103 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, 2022 in Database by gaurav
• 23,580 points
4,408 views
0 votes
1 answer

Excel data to table on Dashing Dashboard?

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

Apr 11, 2022 in Database by gaurav
• 23,580 points
1,107 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, 2022 in Database by gaurav
• 23,580 points
8,534 views
0 votes
1 answer

Strange and Incorrect Excel Formulas Result?

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

Apr 11, 2022 in Database by gaurav
• 23,580 points
951 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, 2022 in Database by gaurav
• 23,580 points
853 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,580 points
2,960 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, 2022 in Database by gaurav
• 23,580 points
4,155 views
0 votes
1 answer

Excel Remove Decimal Places

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

Apr 11, 2022 in Database by gaurav
• 23,580 points
1,049 views
+1 vote
1 answer

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

i am using in angular its work ...READ MORE

Apr 13, 2023 in Database by manisha

edited Mar 5 160,871 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, 2022 in Database by gaurav
• 23,580 points
1,390 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, 2022 in Database by gaurav
• 23,580 points
1,845 views
0 votes
1 answer

Vlookup Formula in Excel VBA

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

Apr 11, 2022 in Database by gaurav
• 23,580 points
1,232 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,580 points
1,683 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,580 points
2,924 views
0 votes
1 answer

Use python extract images from Excel sheets

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

Apr 11, 2022 in Database by gaurav
• 23,580 points
14,012 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,580 points
3,266 views
0 votes
1 answer

Excel sort function to "skip" 1st row

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

Apr 11, 2022 in Database by gaurav
• 23,580 points
6,396 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,580 points
2,213 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, 2022 in Database by gaurav
• 23,580 points
11,055 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, 2022 in Database by gaurav
• 23,580 points
8,069 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, 2022 in Database by gaurav
• 23,580 points
9,535 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,580 points
2,123 views
0 votes
1 answer

How do I split a cell in Excel into two or more where they are divided horizontally?

Table cells should be combined. To make a ...READ MORE

Apr 6, 2022 in Database by gaurav
• 23,580 points
24,328 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,580 points
2,127 views
–1 vote
1 answer

How to add prefix in excel ?

Using the Concatenate Function in Excel, you ...READ MORE

Apr 6, 2022 in Database by gaurav
• 23,580 points
85,790 views
0 votes
1 answer

I have a Run Time Error 91 for an Excel Add In

When there was no unhidden workbook open ...READ MORE

Apr 6, 2022 in Database by gaurav
• 23,580 points
1,339 views