<div>
Need to fix few syntax issues.. 
 
1. DISTINCT keyword is for the entire SET and it has to be specified only once for all columns in SELECT clause unless you have any Aggregate functions available. 
2. In the WHERE clause it should be IS NOT NULL instead of just NOT NULL 
corrected code below.. 

<pre><code class="code-1 nolinks" id="code-20-42745818-1">SELECT DISTINCT First_Name, last_name FROM CHECKED_OUT WHERE Book_ID IS not null
</code></pre>
</div>

<div>
Wondering whether this is any assignment or something, kindly confirm..
</div>

<div>
@Raja Jegan R 
gudii9 appears to be undertaking a crash course in SQL, there was a flurry of similar questions earlier also asking for learning guides/places to learn/places to trial things 
&nbsp;========= 
 
SELECT DISTINCT (First_Name ), distinct (last_name) FROM &nbsp;CHECKED_OUT WHERE &nbsp;Book_ID &nbsp;not null 
 
why above query not working because &nbsp;you need &nbsp; IS not null (you were missing the IS ) 
 
can i put one distinct for both first name and last name NO 
In fact &quot;select distinct&quot; makes THE WHOLE ROW &quot;distinct&quot; 
i.e. it compares each row to all other rows and only if a row has some difference will it remain in the result 
 
SELECT DISTINCT First_Name, last_name FROM &nbsp;CHECKED_OUT WHERE &nbsp;Book_ID IS NOT NULL 
 
PLEASE remember that the word distinct belongs to the select here, as in SELECT DISTINCT 
and that, distinct IS NOT a function so it does NOT take the column name/s as a parameter 
 
are these queries case sensitive like unix? 
NO for SQL, but literals might be case sensitive 
 
e.g. 
select distinct = SELECT DISTINCT = SeLecT dIStinCT = Select Distinct 
 
but 
 
where column1 = 'ThisMightBeCaseSensitive' &nbsp; 
 
 
So, to answer this simply really isn't possible. Again &quot;which database&quot; &nbsp;absolutely matters here. &nbsp;e.g. 
Oracle data is usually case sensitive, but not always 
SQL Server data is usually case insensitive, but not always 
 
So. SQL commands are NOT case sensitive but DATA can be
</div>

MI and Automation

jtrifts

Sr. IT Engineer

Gerwin Jansen

gudii9

<div>
<div class="content wysiwyg-content">
SELECT DISTINCT (First_Name ), distinct (last_name) FROM &nbsp;CHECKED_OUT WHERE &nbsp;Book_ID &nbsp;not null 
 
 
why above query not working 
can i put one distinct for both first name and last name 
are these queries case sensitive like unix? 
 
please advise on any good links and resources, videos around this to master
</div>
</div>

SELECT DISTINCT (First_Name ), distinct (last_name) FROM  CHECKED_OUT WHERE  Book_ID  not null


why above query not working
can i put one distinct for both first name and last name
are these queries case sensitive like unix?

please advise on any good links and resources, videos around this to master

distinct queries

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.