BI Portal
Skip to content
  • Home
  • SQL Server
    • SQL Administration
    • SSRS – Reporting Services
    • SSIS – Intgration Services
    • SSAS – Analysis Services
  • SQL Tutorials
    • Handling SQL tables
    • SQL Basics
    • SQL Clauses
    • SQL Commands
    • SQL Functions
    • SQL Operators
    • XML for SQL Server
    • Useful SQL Scripts
    • SQL Online Quiz
  • Power BI reporting
    • DAX
    • Power BI desktop
    • Power Pivot
    • Power Query
    • Sample Reports in power BI
  • Excel
    • Excel functions
    • Excel tutorials
    • Finance math in Excel
  • E-books
  • BI Latest News
    • BI Blogs and Magazines
    • Power BI News
  • Contact
  • English
    • Čeština
    • English

SQL Clauses – List of Articles in Category

Tip: If you are looking for a specific term, search this page via F3 or CTRL + F. No luck? Try search this website using search feature in sidebar

  • Basic SQL Queries – Overview For Beginners With Examples
  • SQL HAVING vs WHERE – What’s the difference?
  • SQL ORDER BY – Sorting Data in SQL Table in Descending or Ascending Order
  • SQL SELECT – Selection of Columns From the Table – Basic Clause
  • SQL SELECT DISTINCT – Removing Duplicates from Table = Unique values
  • SQL WHERE Clause – Adding a condition using SQL

Navigation

» List of Articles on website «

SQL Clauses – List of Articles in Category

Search

Don’t miss out

  • sales reportSales Report in Power BI and Direct Query into SQL Database
    Whenever we set connector to our data in Power BI, we have an option to select connection to a certain object (e.g. a table) or there is a second […]
  • AND, OR Logical Functions in Excel
    Logical functions serve us to test conditions not only in Excel. They can be used in situation when we need to compare 2 or more values and find out […]
  • Excel | Subtotal – 11 Functions in One
    SUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, […]
  • Excel – Function for date and time – YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
    There is a huge number of functions for date and time in Excel. they are used to extract parts of the date or time type of cell. You may have needed […]
  • Power BI Gateway – Introduction Into Tool For Report Refresh/Update
    It is nothing hard to create report using Power BI desktop for example from Excel and then upload it to the cloud on powerbi.com. But how to update […]
  • Connecting to SQL Server | Power Query
    It is possible to connect to many data sources using Power Query (more in this article) and SQL Server database is one of them. This article will […]
  • Power BI Refresh Does Not Work – Reason?
    Did it ever happen to you that the Power BI update did not work? There might be several reasons for this problem and it is always user’s fault. […]
  • WEEKNUM, ISOWEEKNUM,WEEKDAY Excel – Was it on Friday After 15th Week of The Year?
    You have a huge table with many date entries in it. You need to find out which date is after 20th week of the year or if a certain date is Friday. MS […]

News from other Websites

Resources: Power BI News and Blogs a BI Blogs and Magazines – SQL Server, Excel, Reporting

  • 5 Reasons to Reconnect at ODSC East 2022
    by KDnuggets on 23. 3. 2022 at 17:00

    ODSC East is less than a month away - here are five reasons why you should attend, such as learning about trending topics, amazing Keynotes, and the […]

  • A New Way of Managing Deep Learning Datasets
    by Abid Ali Awan on 23. 3. 2022 at 16:00

    Create, version-control, query, and visualize image, audio, and video datasets using Hub 2.0 by Activeloop.

  • The Most Popular Intro to Programming Course From Harvard is Free!
    by Nisha Arya on 23. 3. 2022 at 14:00

    CS50's Introduction to Computer Science has the highest enrollment on Harvard's campus... and is free to anyone interested in taking it!

  • Risk Management Framework for AI/ML Models
    by Vidhi Chugh on 23. 3. 2022 at 12:00

    How sound risk management acts as a catalyst to building successful AI/ML models.

  • KDnuggets News 22:n12, March 23: Best Data Science Books for Beginners; Linear vs Logistic Regression: A Succinct Explanation
    by KDnuggets on 23. 3. 2022 at 10:00

    Best Data Science Books for Beginners; Linear vs Logistic Regression: A Succinct Explanation; Why Are So Many Data Scientists Quitting Their Jobs?; […]

  • Data and database management in everchanging technology landscape
    by roopesh.uniyal@gmail.com on 23. 3. 2022 at 0:00

    This article discusses how the cloud and other technologies help companies to manage their data appropriately in the modern world. The post Data and […]

  • What is Change Management?
    by Additional Articles on 23. 3. 2022 at 0:00

    Change manage is a process to prepare an organization to implement change. In this article, Rohan Kapoor explains the five components of change […]

Iconic One Theme | Powered by Wordpress