Skip to main content

Posts

Showing posts with the label How to use convert function

Example of group by, having,min, max,convert method,get top 5 record etc in sql select query

Example of group by, having,min, max in sql select query select id, min(no) , max(no) id from mytable group by id having min(no) <> 12 order by id; I hope you will get Idea to use group by, having and aggregate function. Select first five record from table in sql To get first 5 records from table you need to use rownum column in select query. Here testtable is table and rownum is column which is physically not visible to it remain in all sql table. select *from testtable where rownum<=5 Select Query to Get Total Experience of All Employee in Sql  This is a Select Query to Get Total Experience of All Employee in Sql . Here Employee is a table name where all master data of Employee exists. SELECT E_ID, E_Name , E_Date_of_Joining, DateDiff('Year', E_Date_of_Joining, GetDate()) As Experience, E_salary FROM Employee  Select query that separate particular part that is separated by special character in sql select query that separate particular part th