Author Archives: Mandeep Singh

SQL Order By Clause

SQL Order By Clause Hi friends, in this post we will learn about SQL Order By Clause. Order by clause is used to sort the result by one or more columns. By default ORDER BY clause sorts the results in ascending order. To sort the result in descending order you have to use DESC keyword. Earlier we

SQL Select Top Clause

SQL Select Top Clause Hi friends, in this post we will learn about SQL Select Top Clause. Top clause is used to get TOP N number of records from table. Top clause can be very useful on tables with thousands of records. Fetching a large number of records can impact performance, so TOP clause is

Like Clause SQL Server

Like Clause SQL Server Hi friends, in this post we will learn about Like Clause SQL Server. Like clause is used with where clause to search specified pattern on a column. There are two wildcard used in like clause. Percent sign:- % Underscore:- _ Earlier we had discussed about SQL AND & OR Operators, SQL Where

SQL AND & OR Operators

SQL AND & OR Operators Hi friends, in this post we will learn about SQL AND & OR Operators. AND & OR Operators is used to filter data from table based on one or more conditions. The AND operator displays a record if both the first condition AND the second condition are true. The OR operator displays

SQL Where Clause

SQL Where Clause Hi friends, in this post we will learn about SQL Where Clause or you can say Where Clause in SQL Server. SQL Server WHERE clause is used to specify a condition while fetching data from table. On given condition satisfaction then only it returns data from the table. WHERE clause is also used in UPDATE, DELETE