Most answered questions in Database

0 votes
0 answers

ORA-00904: invalid identifier

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

May 20, 2022 in Database by Kichu
 • 19,050 points • 992 views
0 votes
0 answers

phpMyAdmin - Error > Incorrect format parameter?

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

May 19, 2022 in Database by Kichu
 • 19,050 points • 1,039 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,050 points • 1,550 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, 2022 in Database by Edureka
 • 13,690 points • 598 views
0 votes
0 answers

Unprotect workbook without password

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

Apr 7, 2022 in Database by Edureka
 • 13,690 points • 413 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, 2022 in Database by Edureka
 • 13,690 points • 809 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, 2022 in Database by Edureka
 • 13,690 points • 333 views
0 votes
0 answers

Datatables export Excel

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

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

Excel formula for reverse percentage calculation

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

Apr 7, 2022 in Database by Edureka
 • 13,690 points • 965 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, 2022 in Database by Edureka
 • 13,690 points • 351 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, 2022 in Database by Edureka
 • 13,690 points • 420 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, 2022 in Database by Edureka
 • 13,690 points • 327 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, 2022 in Database by Edureka
 • 13,690 points • 463 views
0 votes
0 answers

Make sentence from data in cells in Excel

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

Apr 6, 2022 in Database by Edureka
 • 13,690 points • 952 views
0 votes
0 answers

How do I merge two rows in Excel?

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

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 525 views
0 votes
0 answers

How to split a string of text in excel based on a given word?

I have a list of combinations of ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 371 views
0 votes
0 answers

Check Excel file format from PowerScript not relying on file extension

We have a number of Excel files ...READ MORE

Mar 31, 2022 in Database by Edureka
 • 13,690 points • 565 views
0 votes
0 answers

in MS excel find first non n/a value in row

I have dates (Jan-2014 in cell A1, ...READ MORE

Mar 30, 2022 in Database by Edureka
 • 13,690 points • 573 views
0 votes
0 answers

How to loop in excel without VBA or macros?

Is it possible to iterate (loop) a ...READ MORE

Mar 30, 2022 in Database by Edureka
 • 13,690 points • 2,352 views
0 votes
0 answers

How would I use excel to generate a large update sql statement?

I know there's a way to have ...READ MORE

Mar 30, 2022 in Database by Edureka
 • 13,690 points • 2,296 views
0 votes
0 answers

Laravel - Datatables export excel from filtered data

Hello i would like to export data ...READ MORE

Mar 28, 2022 in Database by Edureka
 • 13,690 points • 4,722 views
0 votes
0 answers

Count colored cell on excel automatically

I'm trying to count the number of ...READ MORE

Mar 28, 2022 in Database by Edureka
 • 13,690 points • 320 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,012 views
0 votes
0 answers

Excel PERCENTRANK.INC in Javascript

Is there a way to get the ...READ MORE

Mar 23, 2022 in Database by Edureka
 • 13,690 points • 407 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,581 views
0 votes
0 answers

How to change column datatype in SQL database without losing data?

I have a SQL Server database, and ...READ MORE

Feb 25, 2022 in Database by Vaani
 • 7,070 points • 671 views
0 votes
0 answers

What's the difference between a temp table and table variable in SQL Server?

We can build temp tables in SQL ...READ MORE

Feb 25, 2022 in Database by Vaani
 • 7,070 points • 597 views
0 votes
0 answers

Order Of Execution of the SQL query

I'm not sure what sequence this query ...READ MORE

Feb 25, 2022 in Database by Vaani
 • 7,070 points • 823 views
0 votes
0 answers

SELECT.... WHERE... OR

Is there a method to choose data ...READ MORE

Feb 25, 2022 in Database by Vaani
 • 7,070 points • 347 views
0 votes
0 answers

Select .... where .... OR?

Is there a method to choose data ...READ MORE

Feb 24, 2022 in Database by Hemant
 • 140 points • 343 views
0 votes
0 answers

Testing question and answer

This category discusses everything related to SQL/ ...READ MORE

Feb 24, 2022 in Database by anonymous
 • 140 points • 323 views
0 votes
0 answers

Duckworth-Lewis-Stern calculator to calculate the revised target

With the Cricket World Cup going on, ...READ MORE

Feb 24, 2022 in Database by Edureka
 • 13,690 points • 469 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,557 views
0 votes
0 answers

How to import JSON file to Excel without coding?

Let's say you have a file named input.json which ...READ MORE

Feb 24, 2022 in Database by Edureka
 • 13,690 points • 703 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 • 1,990 views
0 votes
0 answers

How Stuff and 'For Xml Path' work in SQL Server?

Table is: Id Firstname 4 abc 4 def 4 ghi 4 jkl 4 mno Required output: Id Name 4 abc,def,ghi,jkl,mno Query: SELECT ID, ...READ MORE

Feb 23, 2022 in Database by Neha
 • 9,060 points • 5,897 views
0 votes
0 answers

SQL: Display Full Name + Filter By Subject

Feb 22, 2022 in Database by Neha
 • 9,060 points • 270 views
0 votes
0 answers

What is "with (nolock)" in SQL Server?

Can someone explain the ramifications of using ...READ MORE

Feb 22, 2022 in Database by Vaani
 • 7,070 points • 595 views
0 votes
0 answers

What is the definition of cardinality in SQL?

My book definition of Database Systems does ...READ MORE

Feb 18, 2022 in Database by Neha
 • 9,060 points • 744 views
0 votes
0 answers

Selecting COUNT(*) with DISTINCT

In SQL Server 2005, I have a ...READ MORE

Feb 14, 2022 in Database by Neha
 • 9,060 points • 434 views
0 votes
0 answers

How do I UPDATE from a SELECT in SQL Server?

INSERT INTO Table (col1, col2, col3) SELECT col1, ...READ MORE

Feb 4, 2022 in Database by Vaani
 • 7,070 points • 484 views
0 votes
0 answers

how to create a SQL table?

Feb 1, 2022 in Database by Neha
 • 9,060 points • 386 views
0 votes
0 answers

what does sql stand for?

Feb 1, 2022 in Database by Neha
 • 9,060 points • 229 views
0 votes
0 answers

How to add constraints in SQL?

Jan 31, 2022 in Database by Neha
 • 9,060 points • 270 views
0 votes
0 answers

how to use sql server management studio

Jan 31, 2022 in Database by Neha
 • 9,060 points • 281 views
0 votes
0 answers

How to Secure Postgres in cilium like Cassanda.

I want help in writing  code in ...READ MORE

Oct 14, 2020 in Database by Aryan
 • 190 points • 808 views
0 votes
0 answers

I need data from the the site of Justdial for my business. Anybody can tell from where do i get that?

Sep 1, 2020 in Database by Satish
 • 120 points • 718 views
0 votes
0 answers

'NoneType' object has no attribute 'name'

in the models.py: name = models.CharField(max_length=50, db_index=True) gender = ...READ MORE

Jun 18, 2020 in Database by prince
 • 120 points
edited Jun 18, 2020 by Gitika • 3,425 views
0 votes
0 answers

Request for SQL Query

Hi team, How can I get a distinct ...READ MORE

Jun 8, 2020 in Database by vnk
 • 390 points • 718 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 • 957 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.