Most viewed questions in Database

+1 vote
1 answer

Convert excel column to comma separated list

The CONCATENATE function in Excel can transform ...READ MORE

Apr 6, 2022 in Database by gaurav
 • 23,260 points • 190,004 views
+1 vote
1 answer

How to Insert date value in SQL table

Always use ANSI default string literal format for date i.e. YYYY-MM-DD like below. INSERT ...READ MORE

Feb 17, 2022 in Database by Neha
 • 9,020 points • 182,773 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 • 159,803 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,370 points • 120,743 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,260 points • 83,178 views
0 votes
1 answer

Save excel as pdf changing its orientation to horizontal

To begin, go to the page layout ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 55,038 views
0 votes
1 answer

How to find 3rd highest salary in SQL

select max(salary)from employeeposition where salary <(select max(salary)from employeeposition where ...READ MORE

Oct 27, 2023 in Database by anonymous
edited Mar 5 • 53,961 views
0 votes
1 answer

How to get comma-separated values in multiple rows in SQL?

Test Data DECLARE @Table1 TABLE(ID INT, Value INT) INSERT ...READ MORE

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

How to convert date to general in excel without losing format?

The steps are as follows: Copy the dates ...READ MORE

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

Check if table exists in SQL Server

I want this to be the last ...READ MORE

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

Convert Number to Words in Excel VBA code

1. Prevent the conversion of the cents ...READ MORE

Dec 30, 2022 in Database by bobh
edited Mar 5 • 36,878 views
0 votes
2 answers

How to send data to my database from html and css Contact Us Form?

Hello @Sign, It is simple to create contact ...READ MORE

Aug 4, 2020 in Database by Niroj
 • 82,840 points • 36,280 views
0 votes
2 answers

Difference between primary key a composite key

candidate  key: It is the collection of ...READ MORE

Oct 14, 2020 in Database by anonymous
 • 31,578 views
0 votes
3 answers

MySQL "Could not create connection to database serve" error

Pls check that you have MySQL server ...READ MORE

Jul 3, 2020 in Database by anonymous
 • 30,331 views
0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

Sep 11, 2018 in Database by CodingByHeart77
 • 3,750 points • 29,967 views
0 votes
1 answer

Calculate Growth rate in Excel

In order to get the Average Annual ...READ MORE

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

Write a SQL query to find the names of employees that begin with ‘S’

Select ename From emp Where ename like"s%"; READ MORE

Oct 7, 2021 in Database by anonymous
 • 27,796 views
0 votes
1 answer

Excel Remove Decimal Places

1) E2 is the cell from which ...READ MORE

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

Different subsets of SQL

The various subsets of SQL are as ...READ MORE

Sep 28, 2018 in Database by Sahiti
 • 6,370 points • 27,388 views
0 votes
2 answers

How to select the nth row in a SQL database table?

SELECT * FROM ( SELECT ID, NAME, ROW_NUMBER() ...READ MORE

Apr 23, 2020 in Database by anand
 • 140 points • 27,047 views
0 votes
1 answer

Which operator is used in the query for pattern matching?

LIKE operator is used for pattern matching, ...READ MORE

Oct 15, 2018 in Database by DataKing99
 • 8,250 points • 24,178 views
0 votes
0 answers

SQL query for distinct professors and courses

There is a database on instructors, departments, ...READ MORE

Aug 26, 2022 in Database by Kithuzzz
 • 38,000 points • 23,684 views
0 votes
1 answer

SQL query - Dept and Employee table, some departments may not have managers

Yes, even though I like using JOINs, ...READ MORE

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

What do ‘Record’, ‘Field’ and ‘Table’ mean in terms of a database?

Record is the collection of fields, possibly ...READ MORE

Oct 6, 2021 in Database by Adebayo fikayo
edited Mar 5 • 22,561 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,260 points • 22,316 views
0 votes
1 answer

Error:Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation.

Hello @kartik, You can resolve the issue by ...READ MORE

May 13, 2020 in Database by Niroj
 • 82,840 points • 21,006 views
0 votes
1 answer

I have to convert utc time to ist in excel

There are no built-in functions for determining ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,690 points • 20,574 views
0 votes
2 answers

Advantages and Disadvantages of Stored Procedure

https://www.quora.com/What-are-the-advantages-of-using-an-SQL-store ...READ MORE

Apr 29, 2019 in Database by anonymous
 • 20,520 views
0 votes
1 answer

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

"Runtime Error 91: Object variable or with ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 20,491 views
0 votes
1 answer

SQL SELECT WHERE field contains words

Use this query to include any of words: SELECT * ...READ MORE

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

Function vs. Stored Procedure in SQL Server

Functions are calculated values that cannot make ...READ MORE

Feb 17, 2022 in Database by Neha
 • 9,020 points
edited Feb 17, 2022 by Neha • 19,522 views
0 votes
1 answer

How do you count if a cell contains partial text in Excel?

With Formulas, Countif Partial String/Substring Match We can ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,260 points • 19,257 views
0 votes
1 answer

Create enum in SQL Server

Just normalize your model properly: create table user_rank ( ...READ MORE

Sep 15, 2022 in Database by narikkadan
 • 63,600 points • 19,025 views
0 votes
2 answers

Database Lock and its types.

Hello Dataking99, A database lock is used to ...READ MORE

Apr 20, 2020 in Database by Niroj
 • 82,840 points • 18,762 views
0 votes
1 answer

MySQL Error: : 'Access denied for user 'root'@'localhost'

Hello @kartik, I did this to set my ...READ MORE

May 4, 2020 in Database by Niroj
 • 82,840 points • 18,591 views
0 votes
1 answer

ORA-12514 TNS:listener does not currently know the service requested in connect descriptor

I had this issue and the fix ...READ MORE

Oct 8, 2018 in Database by Frankie
 • 9,830 points • 18,400 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,250 points • 16,734 views
0 votes
1 answer

SQL Error: ORA-01861: literal does not match format string 01861

Try replacing the string literal for date ...READ MORE

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

What does recursive stored procedure?

Recursive stored procedure refers to a stored ...READ MORE

Sep 27, 2018 in Database by Sahiti
 • 6,370 points • 15,513 views
0 votes
1 answer

How do I change the menu language of Excel Online?

Click on App launcher from any worksheet ...READ MORE

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

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

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

Sigma or Summation function in Excel

The SUM function in Excel is another ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 14,359 views
0 votes
1 answer

Setting mime type for excel document

I assume application/vnd.ms-excel is the standard MIME ...READ MORE

Apr 4, 2022 in Database by gaurav
 • 23,260 points • 14,221 views
0 votes
1 answer

ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

One of the services has not begun ...READ MORE

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

What is the SQL query to get the third highest salary of an employee from employee_table

You can try out something like this: SELECT ...READ MORE

Sep 27, 2018 in Database by Sahiti
 • 6,370 points • 13,219 views
0 votes
1 answer

Find values in a comma separated string in a MySQL query

You can add commas to the left and ...READ MORE

Sep 10, 2018 in Database by Sahiti
 • 6,370 points • 13,057 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,260 points • 12,974 views
0 votes
1 answer

Which is better database vs. flat files?

Difference between database and flat files are ...READ MORE

Oct 11, 2019 in Database by Omaiz
 • 560 points • 12,898 views
0 votes
1 answer

Laravel Excel import using Maatwebsite Excel package with additional columns from View

How to fix: I know you're fed ...READ MORE

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

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

Mar 15, 2022 in Database by gaurav
 • 23,260 points • 12,705 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.