Posts

What is Artificial intelligence?

  Artificial intelligence (AI) is  a method that teaches computers to process data in a way that's inspired by the human brain .  AI is often categorized into four main types:  reactive machines, limited memory, theory of mind, and self-awareness.   Here are some other types of AI: Deep learning A subfield of AI based on artificial neural networks. Deep learning algorithms require data to learn and solve problems. Deep learning models can recognize complex patterns in pictures, text, sounds, and other data to produce accurate insights and predictions. Generative AI A type of AI that can create new content and ideas, including conversations, stories, images, videos, and music. Generative AI leverages deep learning and massive datasets to produce high-quality, human-like creative outputs. Narrow AI Also known as Weak AI or Artificial Narrow Intelligence, Narrow AI refers to AI systems that are designed to perform a specific task or a set of closely ...
Post a Comment
Read more

stateSave -State saving - restore table state on page reload.

Image
stateSave -State saving - restore table state on page reload. Enable or disable state saving. When enabled aDataTables will store state information such as pagination position, display length, filtering and sorting. When the end user reloads the page the table's state will be altered to match what they had previously set up.
Post a Comment
Read more

Difference between ROW_NUMBER(),RANK() and DENSE_RANK() function in SQL

Create table #tamp ( EmpID   int identity ( 1 , 1 ) primary key ( EmpID ), Name varchar ( 200 ), Salary int ) select * from #tamp --insert into #tamp values('Rahul',10000) --insert into #tamp values('Vishal',15000) --insert into #tamp values('Mehul',20000) --insert into #tamp values('Hiren',15000) --insert into #tamp values('Amit',15000) --insert into #tamp values('Mihir',20000) ROW_NUMBER() Function keeps increasing integer by one and it is not caring duplicate values RANK() and DENSE_RANK() functions are looking for duplicate values RANK() Function The integer value is increasing by one but if the same value (Salary) is present in the table, then the same integer value is given to all the rows having the same value(Salary) Select * , RANK () over ( order by salary desc ) as rank , DENSE_RANK () over ( order by salary desc ) as denserank , ROW_NUMBER () over ( order by sal...
Post a Comment
Read more