Most viewed questions in Database

+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 • 110,241 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, 2022 in Database by gaurav
 • 22,970 points • 92,349 views
0 votes
1 answer

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
 • 8,940 points • 81,665 views
0 votes
1 answer

Excel convert column to comma separated

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

Apr 6, 2022 in Database by gaurav
 • 22,970 points • 71,004 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
 • 28,287 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 • 27,653 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
 • 27,161 views
–1 vote
1 answer

Add common prefix to all cells in Excel

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

Apr 6, 2022 in Database by gaurav
 • 22,970 points • 24,136 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
 • 22,970 points • 23,272 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,360 points • 22,501 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,740 points • 22,402 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 • 20,932 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
 • 19,257 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,240 points • 18,767 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
 • 17,909 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 • 16,830 views
0 votes
1 answer

SQL query to find third highest salary in company

The easiest way to work this out ...READ MORE

Feb 21, 2022 in Database by Neha
 • 8,940 points • 16,219 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 • 15,620 views
0 votes
1 answer

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

You can refer to the following definitions ...READ MORE

Nov 12, 2018 in Database by Sahiti
 • 6,360 points • 14,544 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 • 13,805 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 • 13,624 views
0 votes
1 answer

Convert Date to Text without losing the format in Excel?

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

Apr 1, 2022 in Database by gaurav
 • 22,970 points • 13,405 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,360 points • 12,747 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,360 points • 12,192 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
 • 22,970 points • 11,557 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
 • 8,940 points • 11,278 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 • 10,412 views
0 votes
1 answer

Multiple rows to one comma-separated value in Sql Server

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

Sep 17, 2022 in Database by narikkadan
 • 59,740 points • 10,374 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 • 10,338 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,360 points • 8,966 views
0 votes
1 answer

How to schedule a job for SQL query to run daily?

down voteaccepted Expand the SQL Server Agent node ...READ MORE

Oct 25, 2018 in Database by Frankie
 • 9,830 points • 8,860 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
 • 22,970 points • 8,688 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
 • 34,760 points • 8,573 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,020 points • 8,027 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,630 points • 8,000 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
 • 22,970 points • 7,390 views
0 votes
1 answer

What are the different types of index?

There are three types of index namely: Unique ...READ MORE

Oct 17, 2018 in Database by Sahiti
 • 6,360 points • 7,336 views
0 votes
1 answer

What are VDL and SDL?

VDL(View Definition Language): Represents user views and ...READ MORE

Nov 13, 2018 in Database by DataKing99
 • 8,240 points • 7,326 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
 • 22,970 points • 6,970 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
 • 59,740 points • 6,868 views
0 votes
3 answers

What is Phantom deadlock?

To understand phantom deadlock, you need an ...READ MORE

Feb 13, 2019 in Database by Ravi kumar
 • 6,750 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
 • 8,940 points
edited Feb 17, 2022 by Neha • 6,422 views
0 votes
1 answer

What is Data partitioning?

This is the process of partitioning tables, ...READ MORE

Aug 22, 2018 in Database by DataKing99
 • 8,240 points • 6,255 views
0 votes
2 answers

Durable Writes in Cassandra

When Cassandra write: 1. memtable (in memory) 2. commit ...READ MORE

Nov 25, 2018 in Database by Amit
 • 180 points • 6,126 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
 • 22,970 points • 5,988 views
0 votes
1 answer

ORACLE LIVE SQL IMPORT CSV DATA (live oracle sql)

Convert CSV to SQL http://www.convertcsv.com/csv-to-sql.htm This programme may be ...READ MORE

Feb 11, 2022 in Database by Neha
 • 8,940 points • 5,961 views
0 votes
1 answer

Excel - how to calculate sum of multiple rows into different columns

The AutoSum button or formula can be ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,630 points • 5,927 views
0 votes
1 answer

ERROR 1006 (HY000): Can't create database 'test' (errno: 2) in mysql

Hi@akhtar, You have to change the permissions or ...READ MORE

Apr 14, 2020 in Database by MD
 • 95,460 points • 5,760 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
 • 22,970 points • 5,659 views
0 votes
0 answers

MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

This is my Stored procedure : CREATE PROCEDURE ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 34,760 points • 5,597 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.